Count Unique Values
Cesar Perez
✭✭✭✭
Hi there, hope someone can help me with the following request. I have a sheet to track delinquent items. An item can be entered in the sheet multiples times for each day it is delinquent. I need to create a rollup sheet that will summarize the data as follows: First by item, then by year, then by month, and then by name. The counts should be done until the item is cleared. The image below shows the columns in the file.
Answers
-
Try looking at the reports function with Grouping enabled.
- Group by Item Code
- Count the number of unique "Date"
- Filter only for items marked as "Delinquent"
- You can also group/Count on Year and month but it might get a bit busy
Brent C. Wilson, P.Eng, PMP, Prince2
Facilityy Professional Services Inc.
http://www.facilityy.com
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives