If then greater than or equal to....

Options
blmccue
blmccue ✭✭
edited 04/26/23 in Formulas and Functions

I am working on a task list that will return green, yellow, or red based on criteria with today's date and the due date. Everything appears to be working unless the total equals the today - the due date + 7. I have this column formula and one cell will not work correctly. Help!

=IF(TODAY() - [Due Date]@row < 0, "Green", IF(TODAY() - [Due Date]@row < Duration@row, "Yellow", IF(TODAY() - [Due Date]@row >= Duration@row + 7, "Red")))


I ended up changing the formula to =IF(TODAY() - [Due Date]@row < 0, "Green", IF(TODAY() - [Due Date]@row < Duration@row, "Yellow", IF(TODAY() > [Due Date]@row, "Red"))).

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!