Calculating percent of dropdown values selected in a cell
Matt C.
✭✭✭
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?
Answers
-
@Matt C. I would create a summary field, name it MAX Values, and put that number in there. The field would be [MAX Values]#
-
Thank you @Eric Law . I think I will create a reference table, since the value is used across multiple sheets. I thought there may be a canned function, but guess not. Thank You
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!