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.

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.

Find more posts tagged with

Accepted answers

All comments

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".

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.