Automation alert for parent rows only

Kelly Dawson

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

Paul Newcome

If you want to only trigger on parent rows, you would insert a checkbox type column and use this column formula to flag only parent rows:

=IF(COUNT(CHILDREN(Traveler@row)) > 0, 1)

Then you would include a condition in your automation of this box being checked.