Extracting data or finding information through several sheet

Elodie

Hello everyone,

Let's say that I sell the same product through several projects.

I would like to know how many of that product I have into my pipeline this week.

Can I extract this information ? I know I can do it with Excel ...

Thanks!

Elodie

Mick Jordan

HI Elodie, are you familiar with reports which should be able to achieve this for you?  

Mick

p_bureau

Hi,

 

you can indeed do that with the Live Data Connector and Excel (with Power Query). You will then be able to do calculation with criterias (like the name of the product).

 

In a Report in Smartsheet however, you will be very limited (no formulas), but this could be enough ! You need all the sheets in the same folder to do that.

 

Best regards,

 

Paul

Paul Newcome

When building a report, you can select multiple sheets from various folders. They don't have to all be in the same folder.