Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Listing unique values in a column, and counting them (group and sum)
I have to import a list of orders and count how many times each unique product was ordered.
So the orders may list the same ITEM hundreds of times (eg: Item123 x10 pieces). I want another list or sheet which displays a UNIQUE list of each item, and a COUNT of how many pieces of that item was ordered. As my order list grows, I need the unique item list and sum to update.
Some people calling this grouping unique values and counting.
It use to be done in Excel with a Pivot table. I'm trying to convince the users to move away from Excel, but I can't find a simple way for a user to do this in SmartSheet. Any thoughts?
I see pivot.smartsheetlabs.com exists but I don't have access to it. Wondering if that is a pivot function that maybe I need.