Listing unique values in a column, and counting them (group and sum)

markm · 01/25/17

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.

Shaine Greenwood · 01/26/17

Hi Mark,

I'm not sure on what that specific functionality is that you found, but it might be a paid add-on to Smartsheet.

I'd recommend reaching out to sales@smartsheet.com and seeing if they can provide more information on what this does.

Hugh McKinney · 04/05/17

Hi Mark... Did you find a solution for this?

Welcome to the Smartsheet Forum Archives

Listing unique values in a column, and counting them (group and sum)

Comments

Categories