Sign in to join the conversation:
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
HI Elodie, are you familiar with reports which should be able to achieve this for you?
Mick
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
When building a report, you can select multiple sheets from various folders. They don't have to all be in the same folder.
How can I delete old sheets I no longer use from my account?
We want to implement single-sign-on at work and have received approval. However, our IT department wants all external partners to have/use Mayo credentials to log into Smartsheet. Not all of our external partners ever set foot on our campus and don't have our company credentials. I have a couple of questions. Has any other…
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
