TODAY Function randomly stopped working in my Summary Metric formulas, how do I fix?

jkt2001

In a SUMIFS function I am using a date check to sum all cells that have an expiry date equal or greater than TODAY: =SUMIFS(Expiry:Expiry, >=TODAY())

This worked for over a year but suddenly is giving an error message, any idea if something in the TODAY function changed?

DKazatsky2

@jkt2001,

I would check all the ranges being used as criteria and ensure all the data is in the format expected.

Eric Law

@jkt2001 please provide a screenshot

DKazatsky2

Hi @jkt2001,

The syntax for the SUMIF formula does not appear to be correct in your example. It should be something like the following.

=SUMIFS({Range to be summed}, Expiry:Expiry, >=TODAY())

Hope this helps,

Dave

jkt2001

https://community.smartsheet.com/discussion/comment/400845#Comment_400845

Yes sorry I omitted the range to be summed but assume the syntax is identical to yours. Sorry I cannot provide a snapshot of the entire SUMIFS formula for privacy reasons, but I am getting an INVALID VALUE response, not an issue with syntax

DKazatsky2

@jkt2001,

I would check all the ranges being used as criteria and ensure all the data is in the format expected.

jkt2001

https://community.smartsheet.com/discussion/comment/400853#Comment_400853

you're a genius, there was one cell pulling an invalid value in the date column, and once I resolved that the rest of the function worked. Thank you!!

DKazatsky2

@jkt2001

Glad it worked out.