Formula not working

Hello, I am trying to make a formula that will automate a symbol based on a text in another column. Below is my current formula that isn't working. Any help would be appreciated!

Designations I would like are: Complete = Green; Planned = Blue; In Progress = Yellow; ON HOLD or N/A = Red

=IF(ISBLANK([RegSci Review Status]@row), " ", IF([RegSci Review Status]@row = Complete, "Green", IF([RegSci Review Status]@row = Planned, "Blue", IF([RegSci Review Status]@row = ON HOLD OR N/A, "Red", IF([RegSci Review Status]@row = In Progress, "Yellow")))))

Find more posts tagged with

Formulas

Accepted answers

Anjanesh Vaidya

Hii RobynK,

Please try the following formula:

=IF(ISBLANK([RegSci Review Status]@row), "", IF([RegSci Review Status]@row = "Complete", "Green", IF([RegSci Review Status]@row = "Planned", "Blue", IF(OR([RegSci Review Status]@row = "ON HOLD", [RegSci Review Status]@row = "N/A"), "Red", IF([RegSci Review Status]@row = "In Progress", "Yellow")))))

Hope it will work. )

Thank You!

Anjanesh Vaidya

All comments

Anjanesh Vaidya

Hii RobynK,

Please try the following formula:

Hope it will work. )

Thank You!

Anjanesh Vaidya

RobynK

That worked!! Thank you so much Anjanesh

Best, Robyn

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.