Is it possible to create a workflow that sends an alert only when the parent row status changes?

Susan Peck

We have a sheet with projects (parent rows) and child rows that are deliverables for the project. The team that needs to know when a project is completed doesn't need to know that individual deliverables (child rows) are completed, just the overall project (parent row).

I can't figure out a way to send an alert to the team when only the parent row status is Complete. Is there some way to limit alerts to parent rows? Am I missing something obvious?

(I realize a workaround would be to use a different status value in the parent row, but that means training a whole department to use a workaround.)

Thanks for your help!

susan

Andrée Starå

@Susan B Peck

Excellent!

You're more than welcome!

You don't have anything else that is specific for the parent rows that could be used?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!