Counting Blank Cells

Options
Brittanyy
Brittanyy ✭✭✭✭
edited 09/01/23 in Formulas and Functions

I need assistance on counting all rows that are blank based upon a status column


The formula I used is: =COUNTIF({Status Blank}, HAS(@cell, "--")).

and I tried using this formula: =COUNTIF({Blank Status}), ISBLANK(@cell))

The "Status Blank" is referencing the other sheet.

Tags:

Best Answer

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓
    Options

    If your cells are blank, then this should work:

    =COUNTIF({Status Blank}, "")

    However, this will also capture any blank rows (such as those at the bottom of your sheet, so I would use an alternative with another reference to your sheet where there will always be data if the row is to be used:

    =COUNTIFS({Status Blank},"",{Other column}, <>"")

    This will count the blank status where there is data in the other column but ignore any blank rows.

    Hope this helps, but if you've any questions or problems then just post! 😊

Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓
    Options

    If your cells are blank, then this should work:

    =COUNTIF({Status Blank}, "")

    However, this will also capture any blank rows (such as those at the bottom of your sheet, so I would use an alternative with another reference to your sheet where there will always be data if the row is to be used:

    =COUNTIFS({Status Blank},"",{Other column}, <>"")

    This will count the blank status where there is data in the other column but ignore any blank rows.

    Hope this helps, but if you've any questions or problems then just post! 😊

  • Kaveri Vipat
    Kaveri Vipat ✭✭✭✭✭✭
    Options

    Hi Brittanyy, 

    Please try the following formula, ‘Status blank’ is the range you are referring to from the other sheet, and “” is for finding all the blank cells in the range. 


    =COUNTIF({Status Blank}, "") 

    Thanks,

    Kaveri Vipat

    Senior Associate - Smartsheet Development, Ignatiuz Software

    2023 Core Product Certified

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"

  • NickBlocker
    NickBlocker ✭✭✭
    edited 12/18/23
    Options

    Hi There SS Gurus!

    I am having a similar issue. I have blank cells I would like to count however; the formula is returning #UNPARSEABLE

    =COUNTIF([Assigned To]:[AssignedTo], "")


    Nick Blocker - Analytics Adventurer

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    Hi @NickBlocker

    I hope you're well and safe!

    Try something like this.

    =COUNTIF([Assigned To]:[Assigned To], "")

    Did that work/help?

    I hope that helps!

    Have a fantastic week & Happy Holidays!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • NickBlocker
    NickBlocker ✭✭✭
    Options

    @Andrée Starå - That worked! I have no idea what happened yesterday as that is the formula i was using but gave me the ##UNPARSEABLE however; this morning its working........

    I appreciate your quick response and solution!

    Nick Blocker - Analytics Adventurer

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    @NickBlocker

    Excellent!

    Happy to help!

    Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!