Creating a Pareto of data in multiple columns

I am analyzing data pertaining to manufacturing defects (example below), and cannot seem to summarize the defect codes into an organized Pareto. Feel like I may be missing something, as I'm pretty new to Smartsheet. I can do a sheet summary, but that will not allow me to generate any type of visual chart.


Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @rprice1027

    What I would do with this data is have a second sheet with formulas as a metric sheet to be the source of your chart.

    One column in this metric sheet would list all the possible options, e.g. "Missing space blocks".

    The column next to it would have multiple COUNTIF formulas added together:

    =COUNTIF() + COUNTIF() + COUNTIF()... one for each column. Adding all 5 together will give you a COUNT of how many times that value appears in your other sheet.


    =COUNTIF({Cabinet defect 1}, [Column Name]@row) + COUNTIF({Cabinet defect 2}, [Column Name]@row)...


    Each of {these} cross sheet references would point to one column, and the [Column Name]@row would be looking in the current metric sheet to where you house the defect you're searching for.

    Let me know if this makes sense or if you'd like to see screen capture examples.

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!