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

Susan Peck
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!


Best Answer