[ad_1]
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= 70-84
Red= 69 or less
I dont even know if this is possible but I figured this is the place to ask
TIA
|
Sources 2/ https://community.smartsheet.com/discussion/118282/need-to-populate-health-dot-based-on-data-in-target-measurement-column The mention sources can contact us to remove/changing this article |
[ad_2]