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

Column Type Reverts to Dropdown List
I have a sheet, that no matter how many times I change a Column Type to Check Box, it reverts back to Dropdown list. What could be the source of the issue? I can't find any automations or Data Shuttle items that would even reference this sheet. This column is a formula that is referencing a check box on another sheet, so…
HOW-DO-I: Send All Row Attachments when PDF is generated?
I'm trying to attach all row attachments to an email using automations. The problem is that the system seems to only include attachments that were generated by that process, and the files I need attached are from two different processes. Files: image.png - Uploaded to the form. It currently shows in the approval page (Not…
Using a Summary Sheet?
Hello, I currently have a sheet that has the following columns: Primary, Address, Tenant, (Other columns)… Task1, Task1 vendor, Task1 Fee, Task1 paid via, Task2, Task2 vendor, Task2 Fee, Task2 paid via, Task3, Task3 vendor, Task3 Fee, Task3 paid via,…Task7, Task7 vendor, Task7 Fee, Task7 paid via. I'd like to copy the rows…

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