Smartsheet SUMIFS returning a zero value but working correctly on Excel
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.
Help Article Resources
Check out the Formula Handbook template!