Auto group like cells

edited 12/09/19 in Formulas and Functions

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?






Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!