Count unique values based criteria


I want to count the unique values in my data, but based on a specific criteria.

I have set up my data as above, and I want to get the unique count of Date and Handyman, but I would like to do it based on the value in the Month column. I know I can manually select the relevant rows for each month, but ideally if I can set up a formula that takes into consideration the Month column that would be ideal.

The formula I have used to get the distinct count of Date and Handyman is =COUNT(DISTINCT({Date and Handyman}))


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!