Getting formula to deliver health symbols

Hi there!
I'm trying to generate a health symbol for a column in my sheet and have created the below. I've indicated that the row is a "symbol row" and have successfully gotten my formula to deliver the the words "Gray" "Green" "Yellow" "Red" but it's not populating the symbol. Any help here? Is it a formatting thing or an issue with my formula?

=IF([Actual Start Date]@row > [Target Start Date]@row, "yellow", IF([Actual Start Date]@row <= [Target Start Date]@row, "green", IF([Actual Start Date]@row > [Target End Date]@row, "red", "")))

Find more posts tagged with

Formulas

Accepted answers

All comments

MarceHolzhauzen

Hi @elle.barks

Assuming that you have made your column type, "Symbols", you need to make sure that the colors you have chosen and selected in your dropdown

Then, make sure your spell the colours the same why that they are in the list - based on your formula, all that seems to be hindering you is the spelling. You need to capitalised the words (Red, Yellow, Green, Blue / Grey)

Hope this helps!

elle.barks

That capitalization really got me! 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.