Count with District formula not working
Hey all. I'm struggling to figure this formula out. I'm trying to pulling from another sheet all quotes that are in the moth of October but each quote has multiple lines so trying not to count those extra lines. All columns are text formula. I keep getting an #unparsible return. It works without the distinct piece in there so I know it's something to do with that but can't figure it out. Any help would be amazing! Thank you in advance!
Answers
-
Hey @Christy Kooiman
=COUNT(DISTINCT(COLLECT({Primary Quote}, {Month/Year},[Category 1]1)))
Will this work for you?
Kelly
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 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!