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", "")))
Answers
-
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!Marcé Holzhauzen
Solution and Delivery Consultant with Award Winning Partner
Want to meet?Check my availabilitywww.prodactive.co.uk
If this helped, help me & the SSC by accepting it and reacting w/💡insightful, ⬆️ Vote Up, and/or ❤️Awesome. -
That capitalization really got me! Thank you so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!