Health Check Using Nested IF with Various Criteria

Marcela Hernandez
Marcela Hernandez ✭✭✭✭
edited 10/03/22 in Formulas and Functions


I am trying to created a nested IF formula and stuck. A column was created for each color to help with validation. Originally, YELLOW was set at IF([Time Left]@row >= 3), but then both YELLOW and GRAY would highlight. Note: That any value would return a yellow ball that is greater than 3, even N/A. When the value is 2 or less, the cell is blank.

Now, have updated yellow to include a range, but an error is returning with the exception of cells with values less than 3.

Below are the values that will need to be built into a single formula for a health check column.

RED: =IF([Time Left]@row = "Past Due", "Red")

YELLOW: =IF([Time Left]@row >= 3, IF(AND([Time Left]@row <= 6, "Yellow"))) - Triggering #Incorrect Argument Set

GREEN: =IF([Time Left]@row <= 3, "Green")

GRAY: =IF([Project Status]@row = "Complete", "Gray")

Appreciate your help! Muchas gracias in advance.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!