Is it possible to get a data set based on status for different states?

STLLunatic18

I have a tracker that i am responsible for and the tracker keeps track of status for questions/concerns that i receive from different states. I want to be able to create a chart that shows how many open requests i currently have for the different states. Is that possible?

Itai Perez

Hey,

Can you add some screenshots so it's easier to understand what exactly do you need?

It seems like you might need to use an analysis sheet and use the COUNT formula on the status, then create the chart according to the summary sheet.

STLLunatic18

See below. I have a large list of items i am tracking and want to be able to show what states have an open status.

Itai Perez

Hey @STLLunatic18,

I think what you are looking for might be a COUNTIFS formula, you can use a new sheet to create your list.

In the first column you will have the list of states available and in a second column you will have the formula.

=COUNTIFS({State Column in Tracker}, State@row, {Status column in tracker}, "Open")

Hope that helps!

If I missed anything let me know.

STLLunatic18

This very helpful Itai, thank you!

What if i have several status, can i do:

=COUNTIFS({State Column in Tracker}, State@row, {Status column in tracker}, "Open", "Waiting on Response", "Sent Followup")

Or is there a function to do every status that is not "Closed"?

Thanks again for your help!

Paul Newcome

In this case it would be easier to create a report. Filter it by status, group it by state, then include a count type summary within the report.

Then you can use this report to populate a chart on a dashboard or at the very least make it easier to manage everything that you have open.