Count if Critieria with Eliminating duplicates

Hi, I am trying to count how many of my tax id numbers without duplicates from (Column name TIN) that are associated with a certain contract type "AFF" contract (Column AFFDNGEMP). I have tried the Count if formula but it does not give me the number of TINs without duplicates. How can I combine the two formulas so that I can role this up to a visual for my dashboard? HELP!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!