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

thanks!

Find more posts tagged with

Accepted answers

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

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.