Should work, but doesn't

prosin

Hi,

I'm super new to Smartsheet (less than a month), but trying to update a sheet that was already created. Basically, I'm trying to add a second positive value to a column. Here's my formula that works currently:

=IF(AND([Health Screening Form]@row = "Received"), IF(AND([Background Check Documentation]@row = "Received"), IF(AND([Covid Vaccine Card Uploaded]@row = "Received"), IF(AND([Badge Photo Uploaded]@row = "Received"), 1))))

I am trying to add "Not Needed" and "Waived" as other positive options to the Covid Vaccine Card row, but just can't seem to get the right language. I'm sure it's an easy fix, so any help would be appreciated.

RAdamowicz

Hi! You need to add an OR condition for a positive result to return for multiple options in the same column. Try:

=IF(AND([Health Screening Form]@row = "Received",  [Background Check Documentation]@row = "Received", OR([Covid Vaccine Card Uploaded]@row = "Received", [Covid Vaccine Card Uploaded]@row = "Not Needed", [Covid Vaccine Card Uploaded]@row = "Waived"), [Badge Photo Uploaded]@row = "Received"), 1)