PLEASE tell me what is wrong with this formula

Options
Kitty
Kitty ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

=IF(Status8 = "Complete", "Blue", IF([Due Date]8 < Today8, "Red", IF([Due Date]8 = Today8, "Yellow", IF([Due Date]8 > Today8, "Green"))))

Very new at this, but I can't see the problem...

Tags:
· Share on FacebookShare on Twitter

Comments

  • Nic Larsen
    Nic Larsen ✭✭✭✭✭✭
    edited 02/07/19
    Options

    Try:

    =IF(Status8 = "Complete", "Blue", IF([Due Date]8 < Today(), "Red", IF([Due Date]8 = Today(), "Yellow", IF([Due Date]8 > Today(), "Green"))))

    edit: I'd also change to @row cell references. It'll make easier to copy. 

    =IF(Status@row = "Complete", "Blue", IF([Due Date]@row< Today(), "Red", IF([Due Date]@row= Today(), "Yellow", IF([Due Date]@row> Today(), "Green"))))

    · Share on FacebookShare 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!