multiple If AND/OR statements

Options
KevinL
KevinL ✭✭✭✭
edited 12/09/19 in Formulas and Functions

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)

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!