nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

At Risk Flag when Past Due and is not one of multiple status options (drop down)

robzas

I am trying to come up with function that raises flag if past the due date and status is not: 'CANCELLED', 'Customer Testing', 'Pending Sign Off', or ' SIGNED OFF'.

I have tried:

=IF(OR([Current Status]@row <> "CANCELLED", [Current Status]@row <> "Customer Testing, [Current Status]@row <> “Pending Sign Off”, [Current Status]@row <> “SIGNED OFF), 0, IF([Expected End Date]@row - TODAY() <= 7, 1, 0))

Find more posts tagged with

Accepted answers

Paul Newcome

Sorry about that. Need to delete one of the closing parenthesis from the end.

All comments

Paul Newcome

A couple of things...

You want to use an AND function instead of OR.

You are missing some quotes after two of the text strings.

The slanted quotes are called "smart quotes" which (ironically enough) Smartsheet does not recognize. You will need to retype those directly in the sheet to get the quotes that are straight up and down.

All Criteria should be nested in the single AND statement.

Give this a try...

=IF(AND([Current Status]@row <> "CANCELLED", [Current Status]@row <> "Customer Testing", [Current Status]@row <> "Pending Sign Off", [Current Status]@row <> "SIGNED OFF", [Expected End Date]@row - TODAY() <= 7), 1, 0))

Highlighted in bold above are all of the changes.

robzas

Thank you Paul - I still get #UNPARSEABLE when I insert that in....

Paul Newcome

Sorry about that. Need to delete one of the closing parenthesis from the end.

robzas

Thank you! That worked great - appreciate the help!

Paul Newcome

Happy to help. 👍️

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.