Nested IF/AND Formula


I'm receiving an #UNPARSABLE error for the following formula:

=IF(AND([Completion Status]@row="Completed", [Actual End Date]@row<=TODAY()), "1",

IF(AND([Completion Status]@row="In Progress", [Actual End Date]@row> TODAY()), "2",

IF(AND([Completion Status]@row="Not Started", [Actual End Date]@row> TODAY ()), "3", "4")))

Based on the examples of similar formula, I think this is correct. What am I not seeing?



  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    Your syntax looks right. When you place your cursor in the formula does it and the associated columns light up? Put each piece of the if statement into it's own row. Do they all produce a result?Check your column names. Confirm your end date column is set as a date. If none of that works, deleted the formula, save, and then retype it.


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!