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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
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
Check out the Formula Handbook template!