Using Count & Distinc formulas to

Hello everyone!,

I'm having troubles trying to get the count from a list and showing in other sheet (For this image, I put it in the same sheet but I'll on other "data sheet"). In the other sheet; I would like to have the count of unique date related with de responsible Column "Resp". So if someone put any kind of task related with their name, is going to count but with the criteria of the initial date. So in the image you can see that "Diego" has a number 3, beacuse even if the task is the same names, he got 3 different dates , so in that way the formula has to recognize and related the "Resp" & "Initial date".


So if someone can help me, it would be awesome!

I hope I made myself clear,

Thanks in advance

Diego

Best Answer

  • Ryan Sides
    Ryan Sides ✭✭✭✭✭✭
    Answer ✓

    Hi @Diego Cardenas , give this one a try...

    =COUNT(DISTINCT(COLLECT([Initial date]:[Initial date], Resp:Resp, "Diego Cardenas")))

    This formula will work for your current sheet layout. If you want to cross reference to another sheet, just replace the ranges in the formula with your Cross Sheet Reference names.

    Let me know if you run into any issues.

    Ryan

    Ryan Sides

    Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube

    Come Say Hello!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!