Can I import report data into a Smartsheet? Or another suggestion?
I know, it sounds odd. But I use Smartsheets to prepare quotes. Once a quote is approved and a project can move forward, I run a report to gather up all of the material and hardware needs. Works great, but I end up copy and pasting the data from the report into a Google Sheet so that I can break down materials being ordered from their vendor.
For example, my report runs and gathers all of the stuff that I need to order from Home Depot, and sorts it by the vendor. Then I copy and paste that block of data (the Home Depot portion) and drop it into a Google sheet that tallies up the total for the order.
Then I'll do the same, with say a local vendor. In that case, I can copy out of Google sheets and insert a nice segment of spreadsheet into the order email.
After i do this for all vendors, I have extra columns in Google sheets for putting in the date of when the order was placed. Is it on it's way? Is there a delay. When the materials arrive, what day did they arrive on. Etc. Stuff that I need to add to the data gathered from the Smartsheet report, but obviously, I can't add it to the smartsheet report.
It's kind of a pain to have to use the google sheet, because if there's a change in my quote, the report will update but obviously not the google sheet.
I'm open to suggestions on how to make my life easier with this. Suggestions? Or can I insert a report (linked for example) into a Smartsheet?
Thanks,
Chris
Answers
-
Recently I developed a solution for a client to import Material and Tasks by using so-called import templates that is part of a template structure for each project.
What do you think?
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives