Distinct returns invalid value & Report issue I am trying to solve
I am attempting to do a unique on a date column and the column has blanks, is that the problem? Im trying to create a summary Grid to generate this report (probably not going to paste well
Answers
-
Hi @BenRoller
Can you post the formulas that you're using?
It sounds like a COUNT(DISTINCT(COLLECT would work for you, you would just need to make sure that the Date you're referencing in the formula is housed in a Date type of Column, so that when you reference it the formula can find the right value in the other "Planned Start" column.
Try something like this:
=COUNT(DISTINCT(COLLECT({Business Application Column}, {Planned Start Column}, Date@row)))
Let me know if this makes sense and works!
Cheers,
Genevieve
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 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!