Countif function for dropdown (multi select) column

kleinsb ✭✭
edited 07/24/20 in Formulas and Functions

I am trying to create a function/formula to count all of the times a dropdown selection is used in a dropdown (multi select) column but am having troubles. The goal is to create a summary table that includes each of the dropdown options but I am having trouble figuring out how to format the function/formula.

=COUNTIF([Type of Work Order Issue]:[Type of Work Order Issue], CONTAINS("No Work Order", [Type of Work Order Issue]:[Type of Work Order Issue])

^ This is the formula I am working with but it's saying 0 which is not accurate.

Any advice is greatly appreciated!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!