multiple If AND/OR statements

KevinL

Spent a lot of time on this and I'm sure I'm just missing it so if anyone could help, I'd appreciate it.  I'm trying to create a formula where it will check a box if either one of these 2 scenarios happen

1)  If the [Sales Admin CRM Removal Complete] date column is a date

OR

2) If the [Reason for ITS] = "Obsolete Change Request" AND [CRM Update Required]="YES"

 

Here was my best attempt???

=IF(OR([Sales Admin CRM Removal Complete]@row <> "", 1, 2), IF(AND([Reason for ITS]@row = "Obsolete Change Request", [CRM Update Required]@row = "YES")), 1, 2)

Andrée Starå

Hi Kevin,

Try this.

=IF(OR(ISDATE([Sales Admin CRM Removal Complete]@row); OR(AND([Reason for ITS]@row = "Obsolete Change Request"; [CRM Update Required]@row = "Yes"))); 1; 0)    

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

=IF(OR(ISDATE([Sales Admin CRM Removal Complete]@row), OR(AND([Reason for ITS]@row = "Obsolete Change Request", [CRM Update Required]@row = "Yes"))), 1, 0)

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

Did it work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

KevinL

Andrée, Thanks for your help.  Definitely pushed me in the right direction.  The commas version worked!!!  Thanks!

Andrée Starå

Great!

I'm always happy to help!

Best,

Andrée

Paul Newcome

You can also cut out the second OR function, and it should still work for you.

 

=IF(OR(ISDATE([Sales Admin CRM Removal Complete]@row), AND([Reason for ITS]@row = "Obsolete Change Request", [CRM Update Required]@row = "Yes")), 1, 0)

 

I know it's not much of a difference, but it is another option. I personally find it helps me in writing more complex formulas because its a simple breakdown of the pieces.