How To Compare Dates

Options

Why does this:

=if([End Date]7=TODAY,"Yes","no")

return #UNPARSEABLE?

And this:

-if(and([End Date]7<TODAY, [%Complete]<100),"RED", "YELLOW")

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!