Summary of different products from the same column
As a project manager for a locksmith company I use Smartsheet for many things, but would also like to use it as a summary of all products we use for each project.
Example: Sheet 1 contains 44 columns that I want a report from. Each column represents a placement for a product. Each of those 44 columns could potentially contain 50 different products.
I am looking for a way for the report to count these products based on their name, and not on the fact that there is a value in a cell. As for grouping I could only manage to place a total of 3 groups, this will not be enough in this scenario.