Formula to Return Symbols

I am utilizing a formula to return symbols based on a inputs from another sheet. Here is the formula:

=IF([Status Indicator]@row = "1", "Yellow") + IF([Status Indicator]@row = "2", "Green") + IF([Status Indicator]@row = "3", "Red") + IF([Status Indicator]@row = "4", "Blue")

The yellow and green symbol are showing as intended, but the Red and Blue symbols aren't showing and returning the following values: 0Red and 0Blue.

I checked to make sure I was using the right column type. Any suggestions on how to fix? Thanks.

Find more posts tagged with

Accepted answers

Paul Newcome

If it is only supposed to be showing one color at a time, you would want a nested IF statement instead.

=IF([Status Indicator]@row = "1", "Yellow", IF([Status Indicator]@row = "2", "Green", IF(.................

All comments

Paul Newcome

If it is only supposed to be showing one color at a time, you would want a nested IF statement instead.

=IF([Status Indicator]@row = "1", "Yellow", IF([Status Indicator]@row = "2", "Green", IF(.................

Matthew Kmiec

Thanks so much, that worked!

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.