Unparseable error being returned

Michelle Phillips

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

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

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!