Unique Count

Options

Hi -

We have reports that need to go out to a number of donors each year, some donors get multiple reports, while others only get 1. Each gift officer signs a cover letter for each household. So while a donor might appear several times in my sheet, there is only one signature needed.

Is there a formula/count that gives me the distinct count of the number of pieces needed to sign by a gift officer?

Example:

I don't want to display that Mike has to sign 4 letters when 3 of the 4 are going to the same household. Is there anything that can give me a distinct count based on those 2 columns?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!