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.

Sumifs Problem.PNG

Find more posts tagged with

Accepted answers

Dee.M

Thank you Genevieve,

That has worked perfectly.

All comments

Genevieve P.

Hi @Dee.M

Your current formula is searching for the text of ">=01-Dec-2021" since you have quotes around this value. If you're looking for a date, you'll want to use the DATE function, try this:

=SUMIFS([CO Value]2:[CO Value]52, [Date Created]2:[Date Created]52, >= DATE(2021, 12, 1), [Date Created]2:[Date Created]52, <= DATE(2021, 12, 31))

Cheers,

Genevieve

Dee.M

Thank you Genevieve,

That has worked perfectly.

Genevieve P.

Wonderful! Thanks for letting me know, I'm glad I could 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.