multiple If AND/OR statements

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


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)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!