Can RYG balls change based on duration?

Options

Adrienne

Adrienne ✭✭

07/09/22 in Formulas and Functions

I am trying to write a formula where the RYG balls in the health column change color based on duration. For example, if the duration is <3, I would like to display green, 3-5 would be yellow, and anything >5 would be red.

0 ·

Answers

Kelly Moore Community Champion

07/10/22

Hey @Adrienne
=IF(ISNUMBER(Duration@row), IF(Duration@row<3, "Green", IF(Duration@row<=5, "Yellow", "Red")))
Will this work for you?
Kelly

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Edit in report
What do i need to do to make the fields in a report be able to have information added, edited, removed, etc. when the report is open
Is Formula correct?
I am using the formula below to count the number of rows where the "Rounding Tracker Range 2" column equals 1 and the "Rounding Tracker Range 4" column equals "Cindy". But it returns #unparseable. What am I doing incorrectly? =COUNTIFS([Rounding Tracker Range 2]:[Rounding Tracker Range 2], 1, [Rounding Tracker Range…
Unparsable Error for formula
I need to sum data in one column based on the month and year. =SUMIFS({011-AP Archive Computed Count}, {011-AP Archive Month}, 12, {011-AP Archive Year},2025)) I did the same formula for COUNTIFS, and it worked beautifully. =COUNTIFS({011-AP Archive Month}, 12, {011-AP Archive Year}, (2025)) Any help will be appreciated.