I want to get the total rows in a particular column and used COUNTIF or COUNT without a result

Options

The name of the text column is "Name of Service". My formula appears after the last row with data: =COUNTIF(["Name of Service"]:["Name of Service"]) and I get this error #UNPARSEABLE.

I have tried every permutation/combination and cannot figure this out.

Answers

  • Jon Mark H
    Jon Mark H ✭✭✭✭✭
    Options

    Hey LaurenP-

    I've been trying to see if I can figure this out for you -

    Are you entering an argument for when it's counting in that column?

    Ex: =COUNTIF(["Name of Service"]:["Name of Service"], "Room Cleaning")

    The count being the number of times the service of Room Cleaning occurs in the column?

  • LaurenP
    Options

    Thanks, Jon!. I want to count the number of rows in the Name of Service column. I need to use that total count in a dashboard.

  • Jon Mark H
    Jon Mark H ✭✭✭✭✭
    Options

    Ah - if you want to count the number of rows - I would then just do:

    =COUNTIF(["Name of Service"]:["Name of Service"], <>"")

    That will count anything in that column which isn't BLANK.

    -Jon Mark

  • LaurenP
    Options

    I copied your formula and pasted it into the last cell in the Name of Service column. I see an error #UNPARSEABLE. And, when I can click Convert to Column Formula,

    I see this error:


  • Jon Mark H
    Jon Mark H ✭✭✭✭✭
    Options

    Ah, I think I see the issue:

    Is your column named "Name of Service" or just Name of Service (without quotations)

    If it's the latter, the formula will me:

    =COUNTIF([Name of Service]:[Name of Service], <>"")

    That should work for it.

    Are you thinking you need to make this a column formula? Or were you just doing that to see if it would make the formula work?


    -Jon Mark

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!