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.

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.

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.