Unparseable error being returned

I am not finding the error in my formula, Client is a text field and Start and end dates are Date fields. Any help would be greatly appreciated

Regards

Michelle

=IF(AND([Client]1= "In Progress", [End Date]1 < TODAY()), "Moderate", IF(And([Client]1 = "In Progress",[End Date]1 = > TODAY()), "Mild",IF(And([Client]1= "Not Started",[Start Date] <TODAY(-5)),"Extreme",IF(And([Client]1= "Not Started",[Start Date] <TODAY(-4)),"Severe",IF(And([Client]1= "Not Started",[Start Date] =>TODAY()),"Mild", IF(Client1="Completed" , "No Pain"))))))

Find more posts tagged with

Healthcare

Formulas

IT & Operations

Comments

Mike Wilday

Hi Michelle, Your start dates do not reference a row number. Try this one.

=IF(AND([Client]1= "In Progress", [End Date]1 < TODAY()), "Moderate", IF(And([Client]1 = "In Progress",[End Date]1 = > TODAY()), "Mild",IF(And([Client]1= "Not Started",[Start Date] <TODAY(-5)),"Extreme",IF(And([Client]1= "Not Started",[Start Date]1 <TODAY(-4)),"Severe",IF(And([Client]1= "Not Started",[Start Date]1 =>TODAY()),"Mild", IF(Client1="Completed" , "No Pain"))))))

Michelle Phillips

Thank you Mike, so obvious once pointed out.

Regards

Michelle

Mike Wilday

You're welcome! Easy to miss! I have had that happen multiple times. I try to use @row when referencing cells now as @row will only reference the columns in the current row and won't shift or change when i paste it into a new row.

https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell

Paul Newcome

You may also run into an #INVALID OPERATION error once you get the #UNPARESEABLE issue fixed because of this part here...

..... "In Progress",[End Date]1 = > TODAY()), "Mild".......

May need to swap it to

......... "In Progress",[End Date]1 >= TODAY()), "Mild"..........

Mike Wilday

@Paul - Good catch!!! That will produce an error as well.

Paul Newcome

There is also a second instance of this in the second to last IF statement that I missed on the first look.

Michelle Phillips

Thank you Paul, and I did get the 2nd error and actually found that one on my own!

Paul Newcome

Happy to help!

Sign in to join the conversation!

Quick Links

Trending discussions

Compare Previous Week
Hello, I am trying to be able to say whether hours went up or down as compared to the previous week but am having trouble referencing the previous week. I have tried to add a helper column but am still getting an error. Any help would be greatly appreciated!
SUMIFS Formula with Date Column
Hello All, I am using this formula " =SUMIFS({RCX- Kit Forecast - 2025 Range 1}, {RCX- Kit Forecast - 2025 Range 2}, ">=" + TODAY(), {RCX- Kit Forecast - 2025 Range 2}, "<=" + (TODAY() + 5)) " Range 1 is the number column Range 2 is a date column But the value is coming as zero
Workflow to trigger comms when number exceeded but not in between.
Hi, trying to work out how I can get a workflow to trigger only when certain milestone numbers are met. For example, I'd like an email comm to be sent once the sum of a column reaches 50, 100, 150, 200 etc. The number will be entered via a form, very basic, so for example 4 entries could be sent via 4 form inputs (15, 11,…