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.
I'm receiving this message every time I try to open my sheets. I'm the only admin user. I have already performed proper troubleshooting, such as clearing the cache, logging in incognito, and logging out and back in, but the issue remains unresolved. It's been a few days, and I'm unable to track our projects and this…
I’ve created an automation that generates a document and forwards it to the individual specified in a cell. The line item also has several additional attachments associated with it. Is there a way to include those attachments with the generated document?
I have an automation set up that copies a row to another sheet each day. The automation itself works correctly, but the problem is that it copies the formulas rather than the values, which causes the formulas to break and return errors. How can I configure it to copy only the values instead of the formulas?
