DISTINCT COUNT BY DATES

HKaur

Hello, All. I'm new to Smartsheet and trying to find a formula that can pull unique/distinct names by date. For example, one employee can complete multiple reviews per date. I need to pull the total volume of reviews (Date of Review) by employee (Call Reviewed By). So, total reviews for each day for each employee.

Hayley B

Hi H!

The SUM(COLLECT()) functions may be of use here! You can collect values based on multiple criteria (employee name, date completed, etc.) and then sum the return quantity. Basically this function will go look for the employee, count how many times they appear on whatever date, and then sum the instances.

Hope this helps! Link below for more info.

https://www.google.com/search?q=collect+function+smartsheet&rlz=1C1GCEA_enUS971US971&oq=collect&aqs=chrome.1.69i57j69i59j0i433i512l2j46i433i512j69i60l2j69i61.2589j0j7&sourceid=chrome&ie=UTF-8