Need to populate health dot based on data in target measurement column
Trying to populate a health dot (red, yellow, green) based off of target column with the below metrics:
Green = 90% or higher
Yellow= greater than 80% but less then 90%
Red= 79% or less
and then another formula
Green= 85 or higher
Yellow= 7084
Red= 69 or less
I dont even know if this is possible but I figured this is the place to ask
TIA
Answers

You will need to adjust this to match your column name, but it should work.
Formula 1:
=IF(ISNUMBER([Target Column]@row), IF([Target Column]@row < 0.8, "Red", IF([Target Column]@row < 0.9, "Yellow", "Green")))
Formula 2:
=IF(ISNUMBER([Target Column]@row), IF([Target Column]@row < 0.7, "Red", IF([Target Column]@row < 0.85, "Yellow", "Green")))
You will likely be able to see how you can tweak the specific values in these two formulas to set the results to whatever you would like.

Hi @Staci B
For the formulas below Make sure the column properties that contain the formula are set to "Symbols"
For this scenario:
Green = 90% or higher
Yellow= greater than 80% but less then 90%
Red= 79% or less
The following formula should work:
=IF([Health Column]@row > 0.89, "Green", IF([Health Column]@row >= 0.8, "Yellow", "Red"))
For the other formula:
Green= 85 or higher
Yellow= 7084
Red= 69 or less
=IF([Health Column 2]@row > 84, "Green", IF([Health Column 2]@row >= 70, "Yellow", "Red"))

Thanks so much for both of your help
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!