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.

Thank you!

Find more posts tagged with

Education

Formulas

Project Management

Comments

Shaine Greenwood

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")

UWSOM-EQI

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.

Shaine Greenwood

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: https://help.smartsheet.com/articles/2476176-formula-error-messages

#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 to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…