Automations Dilema

dpm1028

My team implements software applications. Often the application we install consists of numerous 'parts'. Each 'part' has an accompanying build sheet:

We use Control Center to stand up a project and it will contain all or most of these sheets. We have automation on the sheets when a date is missed. The problem is the automation runs on all of them and if the same person is on multiple sheets, and meets the criteria, they get an email. One person might get 15 emails - then they basically ignore them.

We tried building 1 sheet with the contents of all the fields from all the logs (sheets), but it was unruly.

I am trying to devise a way to 'collect' all the conditions that result in an email and send them in 1 email.

Any suggestions would be appreciated.

Dan

Stefan

Hi @dpm1028,

did you think about using a report to collect all the rows with dates missed and asssigned to that person?
You could send this report on a regular basis, or put it on a dashboard etc.

Hope this helps

Stefan

dpm1028

Hello Stefan,

I had thought about it, but was not sure how I would do that. Build logic in a report that matches the logic in the sheet automations, then build an automation for the report?