IF STATEMENT

C. Srinidhi Ragunathan

Hi.

I have two columns : Deliverable status and Task status and I have the following conditions applied to the task status column: 

1. If deliverable status = reported or shipped, then task status  = complete

2. If deliverable status  = awaiting results, then task status = ongoing

3. If deliverable status = not required or to be decided (TBD), then task status = not applicable 

 

I created the following formula : =IF([DELIVERABLE STATUS]1 = "AWAITING RESULTS","ONGOING",IF(OR([DELIVERABLE STATUS]1 = "REPORTED,"SHIPPED"),"COMPLETE",IF(OR([DELIVERABLE STATUS]1 = "NOT REQUIRED","TBD"), "N/A")))

 

But its showing that its unparseable. 

Can someone please see what the error in the formula is ?

 

Thank you

Andrée Starå

Hi,

Try this.

=IF(OR([Deliverable status]@row = "reported"; [Deliverable status]@row = "shipped"); "complete"; IF([Deliverable status]@row = "awaiting results"; "ongoing"; IF(OR([Deliverable status]@row = "not required"; [Deliverable status]@row = "to be decided (TBD)"); "not applicable")))    

The same version but with the below changes for your and others convenience.  

=IF(OR([Deliverable status]@row = "reported", [Deliverable status]@row = "shipped"), "complete", IF([Deliverable status]@row = "awaiting results", "ongoing", IF(OR([Deliverable status]@row = "not required", [Deliverable status]@row = "to be decided (TBD)"), "not applicable")))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

I hope this helps you!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting