Automation to Update Status of Tasks

[jcx1028]

I'm building a project management platform. In my current configuration, there is a table for Projects, and another for Tasks. 

When a Project is created, an automation runs to add corresponding Tasks. 

The Project table has a "Status" field, with options for In Progress, On Hold, Canceled, and Done.

When a Project status is changed from In Progress to On Hold, I added an automation that also changes the status of the underlying Tasks to On Hold (so the individuals to whom those tasks are assigned now to pause work on them).

But how would I create an automation to switch that Task status back to In Progress if the parent Project status is changed back?

If I set the trigger to be "when record in Project matches conditions (status = In Progress), it's going to update a lot of tasks that should be updated.

Is there a scripting solution for "if a project was On Hold and now is In Progress, change all underlying Tasks statuses that were On Hold to In Progress"?

[TheTimeSavingCo]

Hmm, I'd suggest using a "Find Record" action to look for Task records that are linked to the triggering Project that have a Status of "On Hold":

And then using a Repeating Group to update all those "On Hold" Tasks to be "In Progress":

Link to base