Count if & Unique Values?


I am struggling to figure out the logic required to count the number of monthly/quarterly/bi-annual/annual items without counting duplicates.

Hoping to determine the number of updates on X frequency without counting duplicates. For example, there are 10 different monthly performance emails but they have been updated 10 times (100 performance emails have been produced). Any guidance is appreciated!

My formula is as follows: =COUNTIFS(DISTINCT([item]:[item]), ,[frequency]:[frequency],"monthly")


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!