Nested IF Statements to Determine Priority

Hi everyone,

I've written nested IF statements for a Risk Register, looking at Probability and Impact to determine the color. It's been a while since I've done this and I'm obviously rusty. Can someone tell me why the following is unparseable?

=IF(AND([Probability]@row = "High”, [Impact]@row = "High”), “Red”, IF(AND([Probability]@row = "High”, [Impact]@row = "Medium”), “Orange”, IF(AND([Probability]@row = "Medium”, [Impact]@row = "High”), “Orange”, “Yellow”)))

Thanks in advance.

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

It is the quotes. See how some are slanted to almost indicate open or closed quotes yet others are straight up and down? The slanted ones are called "smart quotes". They come from programs such as Word and (ironically enough) are not recognized as valid characters in Smartsheet formulas.

Retyping them here, directly in a sheet, or in a text editor program such as notepad gives you the right kind of quotes.

All comments

Adam Murphy

Hmmm, this works for me, yet I see no difference.

=IF(AND(Probability@row = "High", Impact@row = "High"), "Red", IF(AND(Probability@row = "High", Impact@row = "Medium"), "Orange", IF(AND(Probability@row = "Medium", Impact@row = "High"), "Orange", "Yellow")))

DianeO

Well I must have had some invisible character in there?? I don't know but this works!! THANK YOU!

Paul Newcome

Retyping them here, directly in a sheet, or in a text editor program such as notepad gives you the right kind of quotes.

DianeO

Oh Paul that's brilliant. I do remember now from other tools and programming this same thing can happen. Thank you!!!

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.