How do you count unique firms by category?

Pjaanderson

Pjaanderson ✭✭

11/07/22 edited 11/08/22 in Formulas and Functions

I am trying to count the number of unique firms that are tied to a particular user.

0 ·

Answers

Paul Newcome Community Champion

11/08/22

Do you have a list in a sheet somewhere? How is your data structured?

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Help with COUNTIFS with multiple criteria in same range, where to put the OR operator
This is a frequent topic in the smartsheet community, and I think I've read most of the responses, but I can't resolve it for my particular situation. : ( Mostly I get unparseable when I add my OR criterion. This is used on a project portfolio metrics sheet, where I want to count for each particular calendar year how many…
Formula help
This discussion was created from comments split from: Sequential numbering of duplicates.
Numbers Only Formula
Hello, I am trying to have the column "Order/Job #" automatically populate the 6 digit number of the parent row in the column "Customer or Task Name". So basically in the screenshot below, in the WHITE row, column "Order/Job #", it would say 661181. Basically, there will be multiple children rows under each parent, and I…