Date column not working in formula

I have a formula working fine: =SUMIF({Install Date}, MONTH(@cell) = 4, {MFD Count})

And one giving #INVALID DATA TYPE: =SUMIF({Final Install Date}, MONTH(@cell) = 4, {MFD Count})

The only difference is the reference date column. Both are set to Column Type: Date and neither has date restriction checked. Any idea what else could be making this happen? The formulas are identical besides the date column.

Find more posts tagged with

Accepted answers

All comments

Mark.poole

@Suz what about the column you are bringing the information to? as well as the date column in your ref sheet.

Suz

I have a formula sheet that I use for my dashboard so the formulas are not in the sheet they're referencing. The columns w/formulas are regular text columns, both the working one and broken one.

Date column in ref sheet is set to Date, not restricted. Just like the one that's working.

I just tried copying the dates, clearing contents in SS, pasted the dates in Excel, formatting to date, copied back into SS and refreshed and still same error.

Mark.poole

Some times sumif and countif functions wont work until you save and refresh the sheet. See what that does for you.

Suz

refreshed and saved several times. just can't figure this out.

Mark.poole

have you tried rebuilding the formula. I don't know if you copy and pasted. only changing the reference or not. I have seen smartsheet do some really awkward things when it comes to copying and pasting.

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.