I am trying to count unique id's only and have used this formula
I am trying to count unique id's only and have used this formula however, I am getting a blocked error and do not know how to fix it?
Best Answer
-
Are are doing this in a cell or in the Sheet Summary section? What is your ID you are trying to count?
Try this =COUNTIF(br_id:br_id, ="jcepon") but replace the jcepon with what you are trying to look up. That is also assuming your column name is "br_id" yes?
I have used this one in the last when counting different "Status"s of jobs on a dashboard pie-chart: =COUNTIF(Status:Status, ="Requested")
The Status column is setup as a dropdown option with several project phases that periodical get changed.
Answers
-
=COUNT(DISTINCT([br_id]:[br_id])) this is what I am using
-
Are are doing this in a cell or in the Sheet Summary section? What is your ID you are trying to count?
Try this =COUNTIF(br_id:br_id, ="jcepon") but replace the jcepon with what you are trying to look up. That is also assuming your column name is "br_id" yes?
I have used this one in the last when counting different "Status"s of jobs on a dashboard pie-chart: =COUNTIF(Status:Status, ="Requested")
The Status column is setup as a dropdown option with several project phases that periodical get changed.
-
the problem is that I have several duplicate id numbers and I only want to count the 1 unique number
384125
354717
335992
335992
335992
415429
415429
415429
381250
381250
381250
234110
234110
234110
234110
234110
379344
379344
379344
379344
-
A few questions: What is your Column name? What is the Column properties set as?
-
Don't judge my paint skills...
Try to see if you can change your column properties to Text/Number I used your original formula =COUNT(DISTINCT([BR_ID]:[BR_ID]))
-
Text number br_id
-
you mean because I have it in the primary column that is the problem?
-
It should still work even as the Primary Column (default is Text/Number); the only thing I can think of is that the Sheet Summary properties has a unique format. For example if you have it set to Date or if you added a currency to it. I just tried it a few ways and it call comes up with "7"
EDIT @ 11:45am : Do you have the right permission level on the sheet?
-
yes i am admin on sheet
-
what I need is the total number of unique id's, when I move the BR ID to a column that is not primary it did remove the blocking. But the problem now is that I am getting a count of 1 instead of a total number of unique id's
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!