% Selected Option in a column

Options

I am trying to create a formula to display % of selected option from a dropdown in a column. The options are:

  1. I do not know
  2. Yes, I heard about it
  3. Yes, I read it


The column will be populated continuously, therefore 100 or more rows will be eventually populated.

From the column, how do I create a formula to represent % each of the option selected? I should therefore be able to ascertain, for example,

75% of persons selected "Yes, I heard about it". See attached how the column will be represented.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!