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

  • MoniqueM
    MoniqueM ✭✭✭
    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

  • jcepon
    jcepon ✭✭✭

    =COUNT(DISTINCT([br_id]:[br_id])) this is what I am using

  • MoniqueM
    MoniqueM ✭✭✭
    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.

  • jcepon
    jcepon ✭✭✭

    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

  • MoniqueM
    MoniqueM ✭✭✭
    edited 01/13/22

    A few questions: What is your Column name? What is the Column properties set as?

  • MoniqueM
    MoniqueM ✭✭✭

    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]))

  • jcepon
    jcepon ✭✭✭

    Text number br_id

  • jcepon
    jcepon ✭✭✭

    you mean because I have it in the primary column that is the problem?

  • MoniqueM
    MoniqueM ✭✭✭
    edited 01/13/22

    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?

  • jcepon
    jcepon ✭✭✭

    yes i am admin on sheet

  • jcepon
    jcepon ✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!