A formula for totaling question

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.

Find more posts tagged with

Formulas

Reports

IT & Operations

Conditional Formatting

Comments

J. Craig Williams

Look at COUNTIFS.

https://help.smartsheet.com/function/countifs

Craig

(note: if you have only one criteria, COUNTIF also works, but I never use it because there is no reason to)

Ofir Marco

Hi Rick,

I have done something similar only with a column of risk level status (Values: "High", "Medium", "Low").

Created 3 columns, one for each value.

Here is an example of the formula i applied on the high Risk level column:

=COUNTIF([Risk Level]:[Risk Level], "High")

Then, i have created a chart that points on the results cells (See attachment).

Hope that helps.

Rick Segal

Thank you very very much. Now neck deep in learning functions. Documentation, who knew?

Rick Segal

This is perfect. Like totally and completely what I was looking for.

Thank you very very much!

Rick

Ofir Marco

You're welcome!

Glad to know it helped.

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…