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!!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!