IF Function Resulting in Specific Symbol Given Specific Inputs from other Columns

Hi all,

Wondering if I could get some help on writing out a function. I know that it will probably be some sort of advanced and lengthy IF function but am confused on how to write it out.

I have a Smartsheet that is used to track data inputs from a form. This data is related to a specific order coming in. I would like to use a symbol to indicate that there are not any problems with the corresponding order. A non-issue order would be defined by an assortment of specific parameters in each column. Essentially, each criteria per column has to be met in order for the order to be marked as "Yes".

For example:

The first entry is marked with a checkmark (Yes) because: [Entered Into System Date]1 is not blank, [Tracking Number]1 is not blank, [Appointment Scheduled]1 has a dropdown selection of "Yes", [SKU Present?]1 has a dropdown selection of "Yes", and [Issue Type]1 is blank.

The other two rows are not marked with a checkmark because they do not me the specific requirements in some capacity.

Thank you!

Find more posts tagged with

Formulas

functionality

Accepted answers

Dan W

If I'm understanding correctly, this will work.

As long as the date is not blank, the appointment and SKU is equal to Yes. Then the Symbol will be Green

=IF(AND([Entered Into System Date]@row <> "", [Appointment Scheduled]@row = "Yes", [SKU Present]@row = "Yes"), "Yes", "No")

Adding AND after IF lets you put in multiple criteria that must match. The <> means does not equal, "" means blank.

All comments

Dan W

If I'm understanding correctly, this will work.

As long as the date is not blank, the appointment and SKU is equal to Yes. Then the Symbol will be Green

=IF(AND([Entered Into System Date]@row <> "", [Appointment Scheduled]@row = "Yes", [SKU Present]@row = "Yes"), "Yes", "No")

Adding AND after IF lets you put in multiple criteria that must match. The <> means does not equal, "" means blank.

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.