Returning INVALID DATA TYPE - Definitely shouldn't be

Andy_DAI

Hello -

This one has got me pulling my hair out. This USED to work. NOTHING has changed.

=SUMIFS({WAP Total}, {WAP Date}, MONTH(@cell) = MONTH(TODAY()))

Returns #INVALID DATA TYPE

But... it's not. WAP Date is DEFINITELY a date data type and

=SUMIFS({WAP Total}, {WAP Date}, @cell = TODAY()) works just fine...

This formula is summing the total of deposits over the current month for a particular client. By the way, YEAR() and WEEKNUMBER() are returning the same errors. I've check, rechecked, then checked again - WAP Date is 100% a date column.

This exact same formula is working in the exact same manner for other clients.

I'm suspecting that something in the actual smart sheet itself is corrupt.

Any help would be appreciated.

Andy

Paul Newcome

I would check the data within the date range itself. If you have any non-dates or blanks, then it will throw an error on the MONTH function.

Try wrapping it in an IFERROR something like this and see if it works for you...

=SUMIFS({WAP Total}, {WAP Date}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()))