Counting the number of empty cells I have

Afolakemi Jedidiah

Afolakemi Jedidiah ✭✭

12/03/21 in Smartsheet Basics

Hello,

Hoping someone can help?

How do I use formular to calculate the number of empty cells. I have used " " to identify empty cell but I reckon this is wrong. what is the best approach?

0 ·

Best Answer

Afolakemi Jedidiah ✭✭

12/06/21 Answer ✓

Thank you Cristobal.

0 · Share on Facebook Share on Twitter

Answers

Cristóbal Enrique Santibáñez Pavez ✭✭

12/03/21

=COUNTIF({Range}; "") try this one, it worked for me

0 · Share on Facebook Share on Twitter
Afolakemi Jedidiah ✭✭

12/06/21 Answer ✓

Thank you Cristobal.

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Can I use conditional formatting to highlight a date cell if it is still blank after X days?
I'm creating a tracker to help keep the team on track with our updated timelines. I have a Created Column, a days since receipt column (which shows the # of days since the row was created), then date columns for a few key tasks that need to be scheduled by certain days. We want to set a conditional format that if a date…
Remove completed tasks
Hello, On my sheet using the Status feature, is there a way to have the tasks marked completed removed from the sheet and stored elsewhere? I tried a couple different things but ended up with a report showing the tasks marked completed. I don't want it to copy over, but switch sheets all together.
How to change the initials of a user?
Hi! I can change the names and e-mail addresses, but the initials are taken always as "first letter first name and first letter surname". Can I change it e.g. "John Doe" "JD" in "JoD" or "JDo" or "AB"? Additionally, I would like to ask, if a change of the "circle colour" is possible. Thanks for your help! Marc

Help shape the future of Smartsheet.
Share your ideas and feature requests.