A formula for totaling question

Rick Segal
edited 12/09/19 in Formulas and Functions

I have a sheet that is tracking issues.  One column is a category (bug, feature req, UI issue, etc.).  The selections are defined in a pull down and isn't free form.  I want to create a widget for a dashboard that shows the total number of each category option.  It appears I can't do it directly so I thought of building a formula that creates numeric totals on a separate sheet and then charting that.  How to I create the formula to run through each row with if this, increment that or some such.  


Any thoughts/advice appreciated.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!