Automate Risk Flag

Hi All,

I am struggling with trying to find and create a formula to automate the Risk Flag.

I'd like to use simple logic to provide a flag if any of the ancestor rows have one of the following values

The two columns are Status, with dropdowns, and Risk Level with High, Medium, Low Symbols, and I would like to return a red Flag to the third column if:

Status@row is “Delayed”, or “Not Started” AND/OR Risk Level is Medium or High

Can anyone please recommend the best way to accomplish this?

Thank you!

Find more posts tagged with

Accepted answers

All comments

Mark Cronk

Try:

=IF(OR(Status@row = “Delayed”, status@row= “Not Started”), 1, IF(OR[risk level]@row="Medium", [risk level]@riw="High"), 1,0))

Mark

ABice Norton

Hi Mark,

Thank you for a quick response. It returned Unparsable. I ensured all is spelled correctly and adjusted for the correct spelling of row, but wondering if I should have brackets around the Status Row and should I have spaces before or after the equal sign?

Mark Cronk

I was missing a paren and had a typo in row. Try:

=IF(OR(status@row = “Delayed”, status@row= “Not Started”), 1, IF(OR([risk level]@row="Medium", [risk level]@row="High"), 1,0))

If the column name is a single word you should need brackets around it. Usually spaces don't matter but they make it easier for someone to review the formula.

An unparsable error is usually a spelling mistake, missing paren, missing g comma, etc. Details in link below.

https://help.smartsheet.com/articles/2476176-formula-error-messages

Mark

ABice Norton

hmm, all seems spelled correctly, but It still returns unparseable.

I will keep trying but, may look for an alternative to automate.

Thanks for the 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.