I'd like to download the Excel versions of multiple Smartsheet sheets on a weekly basis to a location on my local machine. Is there a way to do this easily?
There are three ways I know of. I suggest the easy way 1.😀
Method 1: Schedule backup
You get an email.
Con: You have to download and open the zip manually. You have to create a workspace to specify the backup contents.
Method 2: Use the Java backup tool and create an automated task using Task Scheduler (windows case)
Pro: Automatic Backup in Excel format
Con: It isn't easy to set up and back up all the sheets in your account
Method 3: Use Smartsheet API
Pro: Automatic Backup in Excel format of specified sheets
Con: Difficult to setup
I hope you're well and safe!
To add to Jmyzk's excellent advice/answer.
Another option would be to send it as an attachment on a schedule.
I hope that helps!
Be safe, and have a fantastic week!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
I am running VLOOKUP to bring a picture located in a specific row cell over a new sheet cell. The issue is that picture comes as a text (picture name). My ultimate goal is to pull that picture into a dashboard, when trying that, just the text comes If I bring picture directly from the smart sheet where picture is located…
Hello- I am trying to remove the item names from the right side of the gaant chart. Is there a way to get rid of those and preferably add other column information instead? I see the settings pop up but there is no option to get rid of those labels. Thank you!
I have a report that is filtered by a particular folder within a shared workspace... everytime I remove items from that folder the report no longer watches the folder, and it turns into individual items within the folder... Is this common behavior? Has anyone else experienced this behavior recently? I want the subfolder to…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.