Formula issues




I am experiencing the following issue:

In a sheet I maintain my project data is, a single identifier for a completed activity is an entered date. 

If date is lacking in the respective column, other value options are either a blank cell, or a status "Overdue". 

What I am trying to achieve is count how many times in this column range, I have a date entry, which would tell me times the activity is completed. 

I tried with various different formulas, like COUNTIF/s & SUMIF/s, >01/01/01 or by exclusion of blanks & "overdue" entries, but despite those formulas would work in a regular excel sheet, they don't work successfully in smartsheet. 


Do you by any chance have a suggesion how this problem can be solved. 

Thank you in advance!

Venelina Rusinova


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!