Dates in formula AVERAGEIF

Pilarmonia
edited 12/09/19 in Formulas and Functions

Hello,

I have problem with the dates in the formula below (in sheet summary)

=AVERAGEIF([Date of request]:[Date of request], >07.01.2019, [Completed in days]:[Completed in days])

The Smartsheet returns me the value 0 that is wrong cause I have lots of numbers that meet this criterion.

Please advise and thanks in advance

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!