Can Smartsheet Count Dates?

steven.nienaber105336 ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

I have tasks in each month and want to count those tasks within each month in my metrics section.  Here's my formula to calculate February tasks:  =COUNTIFS([End Date]:[End Date], ">=02/1/19", [End Date]:[End Date], "<=02/28/19")

In Excel this works, in Smartsheet I get a 0, but have tasks within those dates.  Help!?!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!