Updating parent status field from children

Hi,

I have a traditional "Production" with child table "Production Tasks" table setup and linked. It encapsulates our company where different departments have tasks for a production and the Production cannot be complete until all tasks are done. I can use Actions to, if the parent has its status changed, push this to all children. Is there a way to do something like a reverse action where if all a Production's Tasks have been set to status complete, it updates the parent? I can think of how to do this via the API but figured there might be something in Actions/Automations that would take care of this.

Thanks!