Wondering if there is an easy way to do this without creating multiple automations. I have 3 status columns and want to move the item to a new group when all 3 status are COMPLETE. Do I need to create multiple automations eg.
if status 1 changes to complete and status 2 + status 3 = complete move item to group
if status 2 changes to complete and status 1 + status 3 = complete move item to group
if status 3 changes to complete and status 1 + status 2 = complete move item to group.
The ideal automation would be WHEN/ IF status 1 = complete, status 2 = complete and status 3 = complete, move item to group.
You have a very good understanding of how it works. Currently, there is no way to combine multiple criteria into a single trigger. I like how you described it. And it would be great if we could to that some day.
Thankyou both for the replies. Its a pity such automations don’t yet exist as I expect they would be used quite a lot, hopefully something coming soon?
As a workaround i have created the multiple automations as suggested above. It’s not ideal but hopefully will work!
I think it is natural for many workflows to have such multicomponent tasks.
If we add the fact that there can several ‘completed’ status options within each status column, it would required dozens of automations.
