Can RYG balls change based on duration?

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 ✭✭✭✭✭✭

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

Look for check in reference sheet checkbox
I am looking for solution to check a box in one sheet if a box is checked in a different sheet. I tested formula with same idea in current sheet with no issues. It just does not work with reference sheet. =IF({Regulatory}@row = 1, 1, 0) #UNPARSEBLE If I substitute reference with column in current sheet it works fine…
Index Match Returning Unexpected Value
I feel like I've posted 1000 Index Match questions this year! I have a formula (below) that is returning and individual who has the same Date Assigned field but not that same MLL ID. The MLL ID is supposed to be the thing that stops the date range from looking at all the cells. I'm trying to get Ciara as a returned value…
Copy Cell Data from One Sheet to Another Based on Matching Values
Hi, I have two sheets that I am working with. One sheet has a URL that I want to copy over to the other sheet. Both sheets have an identifier column titled "Org Unit ID". I have trying to write a formula that checks both sheets for a matching Org Unit ID and then copies the URL from sheet 1 (titled "Concourse_URL List")…