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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!