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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you for your help
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!