Help with IF formula using Today formula and unparseable error
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.