Automation alert for parent rows only

I am setting up an alert if a cell changes from no to yes, however I only have the trigger on parent rows. When I test the alert it is returning an alert for all the children rows. What do I need to do to prevent this? Can I prevent it or do I need the trigger formula on all the rows?

So I want an alert when the If above 90% budget column changes to yes.

Thank you

Kelly

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!