Hi, I have gone through a lot of posts in this community and tried a bunch of formulas and can't get it to work. I have 5 statuses in the Status column dropdown * Not Started * In Progress * Delayed * Behind * Complete I would like the RGYB colour to change based on the status. * Not Started, and Complete - Blue * In Progress - Green * Delayed - Yellow * Behind - Red The most recent formula I tried, which I found in the discussion forum and it was working for the individual that posted is: =IF(Status@row = "In Progress", "Green", IF(Status@row = “Delayed”, "Yellow", IF(Status@row = "Behind", "Red", IF(Status@row = "Complete", "Blue”, “Blue”)))) I continually get an unparsable error. Would greatly appreciate any and all assistance.

RGYB color change based on Status

Kelly Randis

Hi,

I have gone through a lot of posts in this community and tried a bunch of formulas and can't get it to work.

I have 5 statuses in the Status column dropdown

Not Started
In Progress
Delayed
Behind
Complete

I would like the RGYB colour to change based on the status.

Not Started, and Complete - Blue
In Progress - Green
Delayed - Yellow
Behind - Red

The most recent formula I tried, which I found in the discussion forum and it was working for the individual that posted is:

=IF(Status@row = "In Progress", "Green", IF(Status@row = “Delayed”, "Yellow", IF(Status@row = "Behind", "Red", IF(Status@row = "Complete", "Blue”, “Blue”))))

I continually get an unparsable error. Would greatly appreciate any and all assistance.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

See the fancy quotes tucked in here and there that show open vs closed but then you have other quotes that are straight up and down? You want them all to be straight up and down.

Try retyping the formula directly in the sheet, here in the Community, or in a text editor type program such as Notepad.

Everything else looks good to go.

Kelly Randis

Thanks so much, typing it directly into the sheet worked.

DandersonBluIP

Hello,

I would recommend that you use conditional formatting instead of a formula. I also tried your function and received the same error. Here's what I tried:

Hope this helps.

Kelly Randis

Thanks, I'm new to Smartsheet and wasn't aware of conditional formatting. I'll give it a try.

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.