SUMIFs not working in Smartsheet VS Excel

I have the following table

in excel if i use the function


it will return the value of the approval date - 1/1/2020

however when i do this in smartsheet, the formula returns a blank. Does anyone have any thoughts here?

Alternatively - would anyone have another solution to figure this out.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!