Do you know if the Live Data Connector by smartsheet, can be used to automatically download Smartsheets to excel?
Or is there another way to auto download Smartsheets to excel?
Anyone, Please assist.
Hi @A Rose,
The Smartsheet Live Data Connector can be used to read data from Smartsheet and push it into external applications like Excel. For more information on the various ways to integrate the two applications in this way, checkout the Excel section of the Live Data Connector User Guide.
There isn't currently an auto-export feature built into Smartsheet but feel free to submit a Product Enhancement Request to see about getting this considered as a possibility for future development.
Happy to help!
Have a look here.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
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.
Hi @A Rose
You could set up a recurring delivery of the sheet/report as an excel file.
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
✅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!
How do i set that up please?
It's almost as good as auto export sheets to excel, as i can setup rexurring email exports. Perfect.
You're more than welcome!
I realize this thread is a few years old, but curious if your auto-send via Excel has issues with it not displaying correctly in Excel?
I've raised this issue to Smartsheet, and have basically been told that the formatting issue that is persistent from Smartsheet to Excel via the auto-send feature is not a problem, per se, but would fall under the product enhancement category.
Sadly, this is a very disheartening response, as the feature auto-sends just like my sheet/report appears if I send via PDF. Doing so via Excel it doesn't export date fields or wrapped columns correctly, thus the date field is just text and all columns are sized the same. See screenshot below.
If I simply export via Excel, all data and formatting remain in place.
Off I go to submit the enhancement request... :(
I have provided a dynamic view for my users to see content on-screen. However, I've been asked to provide a print option as well. Normally, I would export a report to PDF for 'clean' printing [that is, preserves layout and colours with pretty explanatory note in header]. However, I don't want my users to have access to the…
Hi, Does anyone know if there is a way to send an alert if the value in a cell changes by more than a certain percentage? So, if I have 100 in a cell (text/number) and the value changes by over 5%, I'd like to be able to send an alert. Thanks, Vince
I'm sure this is super simple but myself and a colleague could not figure it out. I have some very simple data I need graphed for a project: Not Started, In Progress, Complete and then % Complete using the total. The pie chart for the Not Started etc. comes out correct: But when I ask it to graph just % complete, it does…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.