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
 10.8K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 56 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!