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
Best Answer
-
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.
Answers
-
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.
-
Alas no, it is still UNPARSEABLE
-
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)) 😊
-
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.
-
Thank you for your help
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!