unable to sum numbers based on date criteria

prathap.krishnashetty69881

Hi,

currently i'm trying to sum up numbers against different dates. here i have different numbers for same date, hence would like to sum up those numbers against a specific date which is my criteria.

i'm not getting the final sum instead formula showing zero.

can anybody help me.

here is the formula i used.

=SUM(COLLECT({Smart Sheet for EmpProd Range 4}, {Smart Sheet for EmpProd Range 2}, "11/17/2018"))

where, EmpProd Range 4 is the column of numbers, EmpProd Range 2 is the date column

 

Paul Newcome

Give this a try...

 

=SUMIFS({Smart Sheet for EmpProd Range 4}, {Smart Sheet for EmpProd Range 2}, @cell = DATE(2018, 11, 17))

prathap.krishnashetty69881

Great! its working. Thanks so much for the quick response.

Paul Newcome

Happy to help. 

prathap.krishnashetty69881

Hi, i want to create a group of contacts in smartsheet, however, no idea how to do this. can anybody help me?

Andrée Starå

Hi Prathap,

Look here: https://help.smartsheet.com/articles/1554165-managing-groups-team-business-enterprise-

Did you get it working?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting