How to restrict Update Request to only notify of incomplete tasks (involves Parent/Child rows)
I have an automation to send an Update Request for incomplete tasks. The sheet is structured with Parent/Child rows. The problem is the automation is reminding owners to complete work that is already marked 100% complete.
Trigger: when a date is reached (every 2 weeks)
Condition: where "100% Complete" does not contain "1" (I also tried "100%")
Action: Request an update. Send to contacts in Assigned To cell.
In the below example, the owner of the 100% complete task is getting a reminder.