Count distinct dates in a year, month and country
Hi,
Can anyone help? I need to count unique dates in a certain year, month and country so i can monitor the unique date entries in that country on a monthly basis in that year.
TIA
Answers
-
Hi Noel,
Do you need these counted as in a sum of the number of unique dates or do you need them listed out? Also, do you need this at the line item level or would you want the value within the entire sheet?
Michael - Alternative Delivery Analyst
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!