How to use result from a multi-select drop down in COUNTIFS formula

Randy Van Winkle
Randy Van Winkle ✭✭✭
edited 04/16/20 in Formulas and Functions

I would like to Count the values from a row that contains 1 value from a Multi-Select and 1 of 2 values from a drop down. I have two formulas for the 2 values because 1 of the drop down values contains a < symbol. Here is what I tried to put together


The first one is not registering any values.


=COUNTIFS([Does customer supply PPE or Consumables]:[Does customer supply PPE or Consumables], "PPE", [Safety Glasses]:[Safety Glasses], "No Supply")


The second one is showing values, but does not seem to be calculating correctly


=COUNTIFS([Does customer supply PPE or Consumables]:[Does customer supply PPE or Consumables], "PPE", ([Safety Glasses]:[Safety Glasses]), CONTAINS("< 2 Week Supply", @cell))

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!