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
 63.8K Get Help
 409 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!