Trying to count instances that match data from 3 separate columns of a smartsheet

Hello, I am trying to COUNTIFS criteria are all met from 3 different columns. I am able to do this for 2 columns but anything I have tried for 2 columns is UNPARSEABLE. Here is the formula UI am triyng at the moment - =COUNTIFS([Type of use]:[Type of use], CONTAINS("IMP", @cell;), [Order Status]:[Order Status], CONTAINS("Completed", @cell), [Product]:[ Product], CONTAINS(”Visipaque”, @cell))

Does anyone have a better formula please - Type of Use; Order Status; Product; are all columns in a single smartsheet

Thank you

Find more posts tagged with

Accepted answers

Paul Newcome

Sorry about that. I also missed the semi-colon in your original formula after the first @cell reference. I saw the quotes right off and missed that other piece. Glad you were able to get it sorted though.

All comments

Paul Newcome

The problem is the quotes in the last CONTAINS function. See how those are slanted but the others are straight up and down? The slanted ones are called "Smart Quotes" which (ironically enough) are not recognized as valid characters in a Smartsheet formula. Try retyping those quotes directly in Smartsheet and see if that helps.

Vanessa Godden

Alas no, it is still UNPARSEABLE

Vanessa Godden

But after trying a lot of variations this seems to work - =COUNTIFS([Type of use]:[Type of use], CONTAINS("RA Samples", @cell), [Order Status]:[Order Status], CONTAINS("Completed", @cell), Product:Product, CONTAINS("Visipaque", @cell)) 😊

Paul Newcome

Vanessa Godden

Thank you for your help

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.