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

Vanessa Godden

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

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.

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

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.

Vanessa Godden

Thank you for your help