How to restrict Update Request to only notify of incomplete tasks (involves Parent/Child rows)

Pam Grant

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.

Automation:

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.

Krissia B.

Hello @Pam Grant

After further testing on this scenario, I recommend your condition to say the following. See images below for reference. Either works to exclude the ones that are already marked 100%.

What my test sheet looks like.

The preview if Update Request includes 100% (Following your setup)

Notice how there's 3 pages because it included the 100%.

With the setup I have recommended above, this is the preview. It only has 2 pages which excluded the 100%.

See more information in the link below.

• Condition Blocks: Filter What Your Automated Workflows Send

Hope this helps! Let me know if you have further questions.

Cheers,

Krissia

Pam Grant

Thank you Krissia

I will try "Is not one of" instead of "does not contain".