Color Symbols Based on Number Ranges

SadieW

SadieW ✭✭✭

10/27/23 in Formulas and Functions

Is it possible to have a red/yellow/green circle symbol appear in a column if the cells of another column meet a certain range criteria? For example, I want a green symbol to appear when a cell has a number between 0-45, yellow 46-75, and red 75+.

Tags:

Formulas

0 ·

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

Index Match
Hello All, =IFERROR((INDEX((COLLECT({Annabelle Pruned}, {Client Name (Pruning)}, [Client Name]@row, {Annabelle Name}, "Annabelle"),1),0) This formula I've used (with the help of the pro desk) elswhere under the same circumstances as the one above: Anabelle pruned is a Boolean, Annabelle Name is a text box. The error is…
Can you help me with a COUNTIFS Formula (Second Criteria)
Trying to count Rows in a sheet that meet 2 criteria. I am not an advanced user, so I am missing something. Can you take a look at this formula and give me some suggestions? =COUNTIFS({Phase-TPN}, "1", [Start SCRA]:[Start SCRA], "Yes")
Can you convert this vlookup to an index match or index collect?
basically, it rest id exists in both SS and on the other SS a field is either checked or unchecked, then result should read Yes. =IFERROR(IF(AND(VLOOKUP([Restaurant ID]@row, {CFA NRO/Remodel Cabling Tracking Range 1}, 1, false) <> 0, VLOOKUP([Restaurant ID]@row, {CFA NRO/Remodel Cabling Tracking Range 1}, 39, false), 0),…