9

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

Functionality
Department

Comments

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

Thank you Mike, so obvious once pointed out.  

Regards

Michelle

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

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