Help with IF formula using Today formula and unparseable error

edited 12/09/19 in Formulas and Functions

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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!