Counting Unique Data Only if Associated Column is Not Blank


Hello again! We really do research these things before we ask! ;)

We are looking to count the unique Store Numbers for "P1 Complete Dates" and "P2 Complete Dates" in the Sheet's Summary Data, so we can make sure each store is only being counted once for each phase.

The formula that we found and tried is only giving a result of 1, which we know is inaccurate.

=COUNT(DISTINCT(COLLECT([Store Helper]:[Store Helper], [P1 Complete Date]:[P1 Complete Date]), <>""))

Test sheet:

Thanks for taking a look!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!