Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Invalid Operation when using Today() in nested IF STATEMENT

Here is the formula I am working with:

=IF(ISBLANK([Start Date]@row), " ", IF(ISBLANK([Actual Start Date]@row), "Not Started", IF(ISBLANK([Actual End Date]@row), "In Progress", IF([Actual End Date]@row > TODAY(), "In Progress", "Complete"))))

When I have dates entered for Start Date, Actual Start Date, and End Date the formula works. When I enter a date for Actual End Date I get invalid operation.

Please help!!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions