Counting blanks (no dates entered) in a sheet column

Just starting out in Smartsheet.

Is there a simple way to just add the number of blank cells in the Date Assigned column. I'd like to use this formula as a value in the Sheet Summary section.

What I've tried so far:

=IF(ISBLANK([Date Assigned]@row), COUNT[Date Assigned]@row, )

Thank you!


________________________________________

Edward Nadareski

(e): [email protected]

(p): (518) 857-1221

Best Answer

  • Brett Wyrick
    Brett Wyrick ✭✭✭✭
    Answer ✓

    Hey Edward.

    That's weird, it is working for me as a Sheet Summary Field:

    As you can see here, I've only got one row that's empty.

    So I get 1. If I delete the "Date Assigned" value from one cell, I get...

    So I'm not really sure what is causing yours to give you a different value.


    Is this the exact formula you're using?

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

    If not, could you possibly send a screenshot of what you're seeing on your end?

    If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.

    Love,

    Brett Wyrick | Connect with me on LinkedIn.

    ------------------------------------------------------------------------------

    2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!

Answers

  • Brett Wyrick
    Brett Wyrick ✭✭✭✭

    Hey @Edward Nadareski, welcome!

    You're so close! Try this instead:

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

    That is working for me on my end, let me know if it works for you!

    If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.

    Love,

    Brett Wyrick | Connect with me on LinkedIn.

    ------------------------------------------------------------------------------

    2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!

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

    Hi @Edward Nadareski

    I hope you're well and safe!

    To add to Brett's excellent advice/answer.

    You'd probably need to add a -10 to the formula because of the 10 extra rows added automatically at the bottom of the sheet.

    Did that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    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 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:[email protected] | P: +46 (0) - 72 - 510 99 35

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

  • Edward Nadareski
    Edward Nadareski ✭✭✭✭

    Hello @Brett Wyrick,

    Thank you very much for your quick response.

    I tried your solution and it is showing "0" as it should be if no blank dates are in the Date Assigned column. So that part worked. However, when I changed one of the Date Assigned entries to a blank...it did not pick that change up. I'm using this command as a Summary section calculation of my sheet.


    Thanks again! -Edward


    ________________________________________

    Edward Nadareski

    (e): [email protected]

    (p): (518) 857-1221

  • Edward Nadareski
    Edward Nadareski ✭✭✭✭

    Hello @Andrée Starå ,

    Thank you as well for your additional insight. For some reason, and I'm not sure yet as to why, I didn't need to put in the -10. Not sure why I'm not getting those extra 10 row entries, though.

    Thank you! -Edward


    ________________________________________

    Edward Nadareski

    (e): [email protected]

    (p): (518) 857-1221

  • Brett Wyrick
    Brett Wyrick ✭✭✭✭
    Answer ✓

    Hey Edward.

    That's weird, it is working for me as a Sheet Summary Field:

    As you can see here, I've only got one row that's empty.

    So I get 1. If I delete the "Date Assigned" value from one cell, I get...

    So I'm not really sure what is causing yours to give you a different value.


    Is this the exact formula you're using?

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

    If not, could you possibly send a screenshot of what you're seeing on your end?

    If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.

    Love,

    Brett Wyrick | Connect with me on LinkedIn.

    ------------------------------------------------------------------------------

    2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!

  • Edward Nadareski
    Edward Nadareski ✭✭✭✭

    Hello @Brett Wyrick,

    I think I figured out what my challenge was. It appears I had a character in two of the cells I was looking at for some reason. But your formula did work after I corrected my oversight.

    Thank you very much! -Edward


    ________________________________________

    Edward Nadareski

    (e): [email protected]

    (p): (518) 857-1221

  • Brett Wyrick
    Brett Wyrick ✭✭✭✭

    Awesome. Glad to help!

    If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.

    Love,

    Brett Wyrick | Connect with me on LinkedIn.

    ------------------------------------------------------------------------------

    2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!