If status is open and risk is high then X

I'm trying to create a formula that references two columns (Status and Risk Rating) to display the "no", "hold" or "yes" symbols. If the Status row is open AND the Risk Rating is High/Medium/Low, etc... I have the formula to work if I am just referencing risk rating IF([Risk Rating]@row = "High", "No", IF([Risk Rating]@row = "Medium", "Hold", IF([Risk Rating]@row = "Low", "Yes"))

I would think the formula would be =IF(AND([Status]@row = "Open", ([Risk Rating]@row = "High", "No" and so on... but it gives me the unparseable error- any advice?

Find more posts tagged with

Accepted answers

All comments

Antonio Figueroa

The formula is the right one you just have to Close the and statement before you finish the If Statement. See Below

=IF(AND([Risk Rating]@row = "High", Staus@row = "Open"), "No", "")

TVang

You don't need the AND() function.

Your IF() statement for evaluating risk_rating (corrected) is

IF([Risk Rating]@row = "High", "No", IF([Risk Rating]@row = "Medium", "Hold", IF([Risk Rating]@row = "Low", "Yes")))

...which works just fine.

You're adding one more condition when Status is 'Open' so the structure of your formula would look like this...

IF( [Status]@row = "Open", your_statement_for_risk_rating , value_for_when_status_not_open )

jcostoplus

Thank you so much!

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.