nested ifs with greater than less than- #unparseable

AndyGfmr
AndyGfmr
edited 12/09/19 in Formulas and Functions

Wrestled with this enough.  Need to call in a friend.  Can anyone figure out what is wrong with my formula?

 

=IF([Last review date]1> 365), "Red", IF(AND([Last review date]1 < 365, [Last review date]1 > 275), "Yellow", IF(AND([Last review date]1 < 275, [Last review date]1 > 0), "Green", "")))

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!