Rabia ✭✭✭
edited 11/16/22 in Formulas and Functions

So I have a source sheet (Permit Intake Form- Virginia), and I’m trying to do a count for the total number of City or Town Permits (Column highlighted below) based on the Unique/Distinct job order number in the column before it. For example: Job Order Number 12345 should have City of Staunton counted once, instead of 3 times for a total City or Town Permit count of 6 (only distinct entries)

I currently have this: =COUNTM({Permit Intake Form- Virginia Range 1})

But it doesn't take the unique entries or the job order number into account. How can I do that?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!