Need help with Counting blank cells in a column.

Options

I need to count the number of blank cells with in a column on another sheet. This is a cross sheet formula where the sheet with the data has a column containing dates. I need to keep a count on the number of cells within in that column that have blank cells(no date) for a particular date range.

The following formula was working for about 5 days and is no longer returning blank cells. No change has been made to either the formula or the data sheet.

=COUNTIFS({Device & Service Checks Date of Closeout}, >=[Start Date]1, {Device & Service Checks Date of Closeout}, <=[End Date]1, {Device & Service Checks Date of Closeout}, "")

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!