IF(OR formula for a Checkbox

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,)


Best Answer


  • Awesome, thanks so much! works great!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!