Auto group like cells

rachel1073

Is there a way to auto group cells that are the same, and add a count of them next to the parent cell? For example, I have a sheet that looks like the first screenshot (ex1), it's a list of SKUs within a program and a project. I want to group all SKUs within the same program/project and count the number of SKUs (see ex2).

 

I found a formula to do this (=COUNT(CHILDREN(Program1)) + " SKUs") but I still need to manually create the parent row, indent the children, copy the formula into the cell, etc., and for a 1000 row sheet, this is a lengthy process.

 

Is there a better way to achieve what I'm trying to achieve? Can I automate this?

 

Thanks!

Andrée Starå

Hi Rachel,

Is it a onetime thing or recurring?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

rachel1073

It's recurring, needed for many of our reports to sr. mgmt

Andrée Starå

I'd recommend taking a look at the premium add-on called Pivot App. 

More info: https://help.smartsheet.com/learning-track/add-ons/pivot-app

Depending on your Smartsheet Plan you might already have access to it. It's included in the Premier plan.

Hope that helps!

Best,

Andrée