Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Counting Blank Cells

Options

Madeline Brannen

Madeline Brannen ✭✭

04/08/16 edited 12/09/19 in Archived 2016 Posts

Is there a way to write a formula that will count the number of BLANK cells?

0 ·

Comments

Travis Employee

04/08/16

Try this!

=COUNTIF(Cell1:Cell5, "")

Replace Cell1 and Cell5 with the first and last cell reference in your range.

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Newbie - Is it possible to restrict row-level access within a sheet?
Is it possible to restrict row-level access within a sheet? I'd like to know if it's possible to give different users access to only specific rows within a single Smartsheet. For example, I have one sheet that needs to be shared with multiple vendors, but each vendor should only see certain rows that are relevant to them.…
How can I automate dashboard charts?
Hi everyone, I'm fairly new to Smartsheet and looking for some advice. I'm in the process of building a project portfolio dashboard and would like to automate a 'Workload Distribution' chart. Currently, I have to manually update a separate metric sheet that serves as the data source, however, with how frequently the data…
Implications on performance by keeping 40+ Workspaces
Hi I'm planning to start storing and processing most of my clients' data from within my Smartsheet Business account (i.e., a separate workspace for each client to ensure data privacy, leading to approx. 30 to 40 workspaces, and gradually even more in the next 2-3 months). My clients have different services requirements (I…