Formula which references dropdown menu with multiple values per cell


I am using a COUNTIFS formula which references a dropdown menu and when I adjusted the dropdown menu to allow for multiple values per cell the formula did not capture the adjusted data. Do I need to use a different formula?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!