Count values in a column or Pivot table

Options
cyndi2403
cyndi2403 ✭✭✭
edited 12/09/19 in Formulas and Functions

Hello,

I don't have a pivot table app so I am looking for formula help.  I have a grid that has a column called "Goal".  Users and choose a value from the drop down or type in their own value in this field.  I need to be able to generate a pie chart that shows the number of times each value shows up in that field.  For example, "Administrative" shows up 5 times, "Process Improvement" shows up 12 times, etc.  Looking for a formula that does this and then I can make a chart from it.  Thanks for your help!

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!