Smartsheet SUMIFS returning a zero value but working correctly on Excel

Dee.M ✭✭
edited 12/06/21 in Formulas and Functions

I am trying to calculate the CO Value if the Date Created in the corresponding rows are Dec-2021.

My CO Value Column is formatted to "Currency" and my Date Created Column is formatted to "Date".

Formula used is as follows:

=SUMIFS([CO Value]2:[CO Value]52, [Date Created]2:[Date Created]52, ">=01-Dec-2021", [Date Created]2:[Date Created]52, "<=31-Dec-2021")

This is returning a €0.00 value.

I have replicated this in Excel and it is working correctly but will not return the correct value in Smartsheet.

Can you please offer a solution.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!