Multiple IF/OR Formula

Adriane Price

Hello ~ I have a status column that our group updates and currently we have it set so that when the team updates the status column of a project to "Completed" the other column will change to "No", if the status column is updated to "Extension" the other column will change to "Yes". I have been requested to add in a couple more variables "Active" & "Tenure" = "Pending"

Current Formula:

l have attempted the following formulas, I do not think I am connecting the dots:

Any assistance is greatly appreciated.

Thank you!!

Aravind GP

Hi Adriane,

You have a couple of options.

Option 1: =IF(Status@row = "Completed", "No", IF(Status@row = "Extension", "Yes", IF(Status@row = "Active", "Pending", IF(Status@row = "Tenure", "Pending")

Option 2: =IF(Status@row = "Completed", "No", IF(Status@row = "Extension", "Yes", IF(OR(Status@row = "Active", Status@row = "Tenure"), "Pending")))

Aravind GP

Hi Adriane,

You have a couple of options.

Option 1: =IF(Status@row = "Completed", "No", IF(Status@row = "Extension", "Yes", IF(Status@row = "Active", "Pending", IF(Status@row = "Tenure", "Pending")

Option 2: =IF(Status@row = "Completed", "No", IF(Status@row = "Extension", "Yes", IF(OR(Status@row = "Active", Status@row = "Tenure"), "Pending")))

Adriane Price

@Aravind GP - ah so I see my mistakes...okay thank you!!! Both work perfectly I appreciate your guidance and assistance.