Distinct returns invalid value & Report issue I am trying to solve

Options

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

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!