Unparseable error being returned

Michelle Phillips
Michelle Phillips ✭✭✭✭
edited 12/09/19 in Formulas and Functions

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

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!