Should work, but doesn't

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.

Find more posts tagged with

Accepted answers

All comments

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)

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.