Count all cells in a column that are NOT blank and do NOT contain a date

Terrell.Boaz52986 ✭✭✭
edited 12/09/19 in Formulas and Functions


I want to create a formula in a date column that allows me to count all of the cells in the column that are not blank but do not contain a date. I have tried various COUNTIFS but can not seem to find the perfect solution. Thank you for your assistance.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!