Calculating percent of dropdown values selected in a cell


I have a multiple select drop down column that has 10 possible values. It's being used as a checklist. I want to calculat the % of values selected in that cell. So for instance. If I checked off 6 things in the drop down out of a possible 10, the formula would return 60%. I know to use COUNTM to count the number of selected values, but how do I count the number of possible Values (10 in this case) that will change as I add or subtract values?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!