If Function - Nested - Negative Percentage - Symbols

Erica Maynard
Erica Maynard ✭✭✭
edited 06/09/23 in Formulas and Functions

I have a formula that is driving me insane. I am trying to get symbols to change color based on the % to Plan column (see screenshot). If the % is positive, I want the On Track Column to show Green. If it is negative BUT greater than -25%, I would like to show Yellow and all others to show Red. The problem is I am getting a #Divide By Zero error. (FYI, the % to Plan is a formula, it is =[Actual 2023]@row - [23 Budget MTD]@row)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!