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

Options

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?

Answers

  • Itai
    Itai ✭✭✭✭✭✭
    Options

    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.

    Itai Perez

    Project Manager | Transformation Department

    Gong cha

    If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

    https://www.linkedin.com/in/itai-perez-740543116/

  • STLLunatic18
    Options

    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
    Itai ✭✭✭✭✭✭
    Options

    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.

    Itai Perez

    Project Manager | Transformation Department

    Gong cha

    If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

    https://www.linkedin.com/in/itai-perez-740543116/

  • STLLunatic18
    Options

    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
    Paul Newcome ✭✭✭✭✭✭
    Options

    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!