Invalid Data Type Error

I have two formulas on different Grids doing the same thing. Formula 1 works, but formula 2 does not. I have double checked the data types of all references and they are the same in both formulas.

={T-Cost} * SUMIFS({T-Total}, {T-Date}, AND(MONTH(@cell) = $Month@row, YEAR(@cell) = [2024]$1))

={Tourn - Cost} * SUMIFS({Tourn - Total}, {Tourn - Date}, AND(MONTH(@cell) = $Month@row, YEAR(@cell) = [2025]$1))

I had the AI formula generator help fix my first formula, but that feature appears to be gone.

Find more posts tagged with

Accepted answers

Paul Newcome

My first guess would be that the {Date Column} has blanks and/or non-date type values in there which would throw that error on the MONTH and YEAR functions. Try an IFERROR around each.

IFERROR(MONTH(@cell), 0) = $Month@row

IFERROR(YEAR(@cell), 0) = [2025]$1

All comments

Paul Newcome

My first guess would be that the {Date Column} has blanks and/or non-date type values in there which would throw that error on the MONTH and YEAR functions. Try an IFERROR around each.

IFERROR(MONTH(@cell), 0) = $Month@row

IFERROR(YEAR(@cell), 0) = [2025]$1

Injury Prevention

Thanks

I had one row in a reference where it was missing a date. That solved the problem.

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.