Automation with OR



I am trying to do an automation to Change the Status depending on Criteria clicked on the same row. I can do it with the trigger being the latest box ticked, but sometimes it doesn't happen in order, so for example:

Status to become Ready for review by PE if Column 2, 3, 4 and 5 ticked, doesn't matter in what order - but my automation would say

Trigger = Box 5 ticked

Condition = Box 2, 3 and 4 ticked

I thought to put

Trigger = any change

Condition = Box 2, 3, 4 and 5 ticked

But nothing at all was working anymore

Thank you for sharing :)

Best Answer