SUMIFs not working in Smartsheet VS Excel

Jia Lee

I have the following table

in excel if i use the function

=SUMIFS($C$2:$C$5,$A$2:$A$5,101,$B$2:$B$5,"Approval")

it will return the value of the approval date - 1/1/2020

however when i do this in smartsheet, the formula returns a blank. Does anyone have any thoughts here?

Alternatively - would anyone have another solution to figure this out.

Find more posts tagged with

Formulas

functionality

Accepted answers

Paul Newcome

For Samrtsheet, you would want to use something along the lines of

=JOIN(COLLECT([Date Column Name]:[Date Column Name], [Site Column Name]:[Site Column Name], 101, [Milestone Column Name]:[Milestone Column Name], "Approval"), " - ")

Paul Newcome

Happy to help! 👍️

Please don't forget to mark an "Accepted Answer" so that others searching for a similar solution know they can take a look here.

All comments

Paul Newcome

Are you wanting to pull the Date where the Site is 101 and the Milestone is Approval?

Jia Lee

Hi Paul,

Yes, I am essentially building a "dashboard" type of view where in each column it is hardcoding a milestone value to check against for a specific site number.

Paul Newcome

For Samrtsheet, you would want to use something along the lines of

=JOIN(COLLECT([Date Column Name]:[Date Column Name], [Site Column Name]:[Site Column Name], 101, [Milestone Column Name]:[Milestone Column Name], "Approval"), " - ")

Jia Lee

Thanks Paul...LIFE SAVER!

Paul Newcome

Happy to help! 👍️

Please don't forget to mark an "Accepted Answer" so that others searching for a similar solution know they can take a look here.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.