Stacked Bar Chart Data Sheet

Options

Hello

I am trying to create a stacked bar chart based on the following:

I have a multi-select dropdown column, so there may be more than one value in it.

I then have a second column with Priority listed.

I have created a sheet that calculates how many times each drop down is used but I want to know how each drop down relates to the priorities.

I'm looking for a chart to show me that, for example, 'user experience' makes up 5 x high priority items and 6 medium items etc.

There are more in the Risk or Issue Type than Priority which is why I want to incorporate the two on the same chart.

Can someone please help me with the formula?


Thanks in advance

Tags:

Answers

  • Leibel S
    Leibel S ✭✭✭✭✭✭
    Options

    @KatieDi

    Using COUNTIFS you can keep on adding ranges and criteria.

    =COUNTIFS({Risk or Issue Type Column}, HAS(@cell, [Risk or Issue Type]@row), {Priority Column}, @cell = "Critical")

    Replace bolded parts of formula as needed...

  • KatieDi
    KatieDi ✭✭
    Options

    This is great, thank you.

    If I wanted to add in another criteria whereby it looks at another column and only counts if a certain criteria is met, e.g. Column name is 'Form Type', and I'm looking to bring in where the form type = contact form.

    I'm sorry, I'm just not very competent at formulas.

    Thank you

    Katie

  • Leibel S
    Leibel S ✭✭✭✭✭✭
    Options

    @KatieDi

    Yes, you can keep on adding as much as you need:

    =COUNTIFS({Risk or Issue Type Column}, HAS(@cell, [Risk or Issue Type]@row), {Priority Column}, @cell = "Critical", {Form Type}, @cell="contact form")

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!