Help with IF formula using Today formula and unparseable error

04/30/19 Edited 12/09/19

I have entered the following formula into a text/number column and I'm getting an unparseable error. I have checked the that column headers are spelled correctly. 

=IF(AND([% Complete]2 < 1, TODAY() >[Finish]2), "At Risk", "Normal"))

I want the sheet to check if a task is not yet marked complete (<100 %) AND the current date is greater than the scheduled finish date, then the task is behind schedule or "at risk". 

I'm new to Smartsheet and this particular formula logic.

Thank you!


  • Hello,

    Looks like you have an extra paren on the end of your function. Try removing it:

    =IF(AND([% Complete]2 < 1, TODAY() >[Finish]2), "At Risk", "Normal")

  • Thank you! That seems to have solved it.

    I can't believe it was that simple!!! Too bad Smartsheet isn't just a little smarter. I'm pretty sure Excel would have caught that and asked me about it.

  • No problem!

    If you ever receive an error on a formula in the future, see our help article for more context on what errors mean:

    #UNPARSEABLE typically means there's an extra paren somewhere or a reference to cells in the sheet is typed incorrectly.

    I also think it would be neat if Smartsheet could bring more context to formula errors in the app. When you have a moment, let our Product team know that you'd like to see that sort of formula error prevention/assistance through our Product Enhancement Request form.

    Wishing you an error free formula experience

Sign In or Register to comment.