I have a “Project Status” column and another 4 columns of statuses:
Operation approval, Finance approval, Management approval, Chairman approval
When each one of the statuses changes to “Approved” , I want the project status column to change value
Can I achieve it via one automation or do I need to create 4 separate automations?
If using automations, you’ll need 4 separate ones since the 4 approvals can come in any order.
You can technically do it in one custom automation, but only if you’re on a Pro or higher plan and using the When any of these conditions are met + multiple IFs logic via the custom automation builder. That said, it gets messy fast and harder to maintain.
Honestly, in most cases it’s cleaner to set up 4 separate automations, one for each approval status change. That way it’s easier to debug and control timing, especially if approvals don’t come in a fixed sequence. I’ve tried the all-in-one route before, but ended up splitting it anyway.
1 Like
Hello!
Yes, you can achieve this with one automation. Configure the automation to trigger when the status changes in any of the four approval columns (“Operation approval,” “Finance approval,” “Management approval,” “Chairman approval”). Add a condition to check if the new status in the triggering column is “Approved.” If both the trigger and condition are met, the automation will then update the “Project Status” column to your desired value. This approach simplifies management and centralizes the logic.