Formula to check a box when specific criteria are met

JessZwei

Hi! I am looking for a formula to check a box when specific criteria are met. I have multiple columns that have dropdown options. I would like the box to check when each of those columns have either "Approved" or "Declined" selected. But if "Submitted" is the option shown, then it should not check the box.

So all columns/cells should have either "Approved" or "Declined", and only when all of the columns have one of these selected, then the box is checked.

Any help is appreciated!

DKazatsky2

Hi @JessZwei,

Give this a try.

=IF(AND(OR([QA Request Status]@row = "Approved", [QA Request Status]@row = "Declined"), OR([QC Request Status]@row = "Approved", [QC Request Status]@row = "Declined")), 1)

Hope this helps,

Dave

DKazatsky2

Hi @JessZwei,

Give this a try.

=IF(AND(OR([QA Request Status]@row = "Approved", [QA Request Status]@row = "Declined"), OR([QC Request Status]@row = "Approved", [QC Request Status]@row = "Declined")), 1)

Hope this helps,

Dave

JessZwei

That's it! Thank you so much, works perfectly!