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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!