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 information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
Help Article Resources
Categories
Check out the Formula Handbook template!