At Risk triggered by formula

Hello!! I'm trying to target the "At Risk" column with a formula to "flag" automatically.

I need to have my At Risk flag marked automatically if a task is overdue [End Date] and the [Status] is "Not Started" and "In Progress"

I tried using this formula:

=IF(AND([End Date]@row <= TODAY(), Status@row <> "Not Started" "In Progress"), 1, 0)

I'm getting an #UNPARSEABLE error

Please help,

Thanks!

Find more posts tagged with

Formulas

Automations

Accepted answers

Frank S.

Hello @Estefania Reyes

Please try this:

=IF([End Date]@row = "", "", IF(AND([End Date]@row <= TODAY(), NOT(Status@row = "Complete")), 1, 0)

Jason Tarpinian

Try:

=IF(AND(End@row <= TODAY(), OR(Status@row = "Not Started", Status@row = "In Progress")), 1, 0)

You've almost got it, just need to throw in the OR function to catch both cases of the status.

Estefania Reyes

Thank you! It worked. :)

All comments

Frank S.

Hello @Estefania Reyes

Please try this:

=IF([End Date]@row = "", "", IF(AND([End Date]@row <= TODAY(), NOT(Status@row = "Complete")), 1, 0)

Nick Korna

Hi @Estefania Reyes,

If I've understood correctly, this should be your formula:

=IF(AND([End Date]@row <= TODAY(), OR(Status@row = "Not Started", Status@row = "In Progress")), 1, 0)

If Status is either "Not Started" or "In Progress" and the End Date is equal to or before today, then the box is ticked.

If I've misunderstood some part of this, let me know and I will correct it. If you've any other questions etc. on this, then just post! 😊

Jason Tarpinian

Try:

=IF(AND(End@row <= TODAY(), OR(Status@row = "Not Started", Status@row = "In Progress")), 1, 0)

You've almost got it, just need to throw in the OR function to catch both cases of the status.

Estefania Reyes

Thank you! It worked. :)

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.