Vertical Automations / Automations by Group

Is there a way to trigger an automation based on the cumulative data by group? For example, notify me when all the items in Group A have column Y data that adds up to X. (notify me when the status is Done on all the items in Group A)

In other words are there automations that work based on data vertically in a column instead of just horizontally?