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

Auto number
I'd like a document numbering intake form that assigns an auto number based on a series of selections. How best to do that within the form/auto column?
How to sort by the summary count in my row report from Highest to Lowest?
SUMIFS when date cell ISBLANK
I'm trying to add "if date cell is blank" criteria to my SUMIFS formula, but get "INCORRECT ARGUMENT SET" =SUMIFS({EBOM - 4" CONDUIT QTY}, {EBOM - 4" JOINT TYPE}, "GSK", (ISBLANK({EBOM - ACTUAL PROD DATE}))) What am I doing wrong?