Why does the count formula not work on date columns?


I simply want to tally how many cells in a column have data, but, if the column is formatted for dates (even with the restriction to only allow dates unchecked), the formula fails with "DATEEXPECTED."

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!