How to sum information from another sheet

Otman

Hi Actually, I have a smartsheet recovering information regarding the products manufactured during the fiscal year Periods P1to P13 (See picture 1)

I would like to sum all the products manufactured by fiscal year period on another smartsheet to regroup them like this (see picture 2)

Picture 1.png

Picture 2.png

Could you please help in how to make a formulation that can sum several lignes with a commun relation (Year fiscal period) on another smartsheet.

Thank you for your help and suggestions 

Paul Newcome

What you actually need is a JOIN/COLLECT and not any of the SUM functions.

=JOIN(COLLECT({Source Sheet Column To Join}, {Source Sheet Period Column}, @cell = "P1"), CHAR(10))

Paul Newcome

What you actually need is a JOIN/COLLECT and not any of the SUM functions.

=JOIN(COLLECT({Source Sheet Column To Join}, {Source Sheet Period Column}, @cell = "P1"), CHAR(10))

Otman

Hi Paul, Thank you very much it's work perfectly as i was expecting.

Have a nice day

Paul Newcome

Happy to help. 👍️