IF(OR formula for a Checkbox

LoriLynn Smith

I believe this is simple, but I am #UNPARSEABLE error.

I have 5 approval columns with Approved, Denied or Received. I want to check all 5 columns, if any one of the columns has received, then select the checkbox.

Here is what I have now, what's missing?

=IF(OR([Approval1]@row, ="Received", [Approval2]@row, ="Received", [Approval3]@row, ="Received", [Approval4]@row, ="Received", [Approval5]@row, ="Received",),1,0,)

thanks!

Nick Burrus

Hello @LoriLynn Smith on Smartsheet it is best practice to not use OR, just stack the IF statements. Give this a try:

=IF([Approval1]@row = "Received", 1, IF([Approval2]@row = "Received", 1, IF([Approval3]@row = "Received", 1, IF([Approval4]@row = "Received", 1, IF([Approval5]@row = "Received", 1, 0)))))

Nick Burrus

Hello @LoriLynn Smith on Smartsheet it is best practice to not use OR, just stack the IF statements. Give this a try:

=IF([Approval1]@row = "Received", 1, IF([Approval2]@row = "Received", 1, IF([Approval3]@row = "Received", 1, IF([Approval4]@row = "Received", 1, IF([Approval5]@row = "Received", 1, 0)))))

LoriLynn Smith

Awesome, thanks so much! works great!