Hi! Curious if anybody knows if there is a way to send a notification if a cumulation of certain columns are changed to a certain status? I know you can kind of do it using “when column changes to status ____, and only if other columns are status ____, then send notification”, but that implied some kind of order, and the when statement column status would have to be update last for the automation to work. Please let me know!
This kind of exists in automation templates for subitems, but not quite what you’re describing.
Looks like this:
You would then send the notification based on that last status change.
Hope it helps! 
Peta | Upstream Tech
peta@upstreamtech.io
+613 9067 5611
Chat with Peta
1 Like
Hi @liamanderson - you are correct, you would need a series of automations to check when each status column changes to Done, to see if the other columns are marked as done as well. For example:
When Status1 changes to done
and only if Status2 is done
and only if Status3 is done
Then Notify …
In the above scenario of 3 status columns, you would need 3 automations.
When Status2 changes to done
and only if Status1 is done
and only if Status3 is done
then notify…
When Status3 changes to done
and only if Status1 is done
and only if Status2 is done
then notify…
Hope this helps,
Mark
1 Like
Hi Mark! Thank you! This should get the job done. Really good idea!
1 Like