How can I offload data from a Smartsheet grid to an existing excel sheet?
I merely want to add on data, and am not looking for a new sheet to be created.
Hi @Devorah Strulovic,
If you plan includes the ability, you can set this up using a Data Shuttle to be done on a schedule or when you select it manually. Your Excel file would need to be on a SharePoint or OneDrive in order to make this set up work.
If you want to see how to get started with Data Shuttle you can read about it here: https://help.smartsheet.com/articles/2483039-Advance-Capabilities-Evaluations#toc-data-shuttle
Hope this helps!
Training Delivery Manager / Charter Communications
@Zachary Hall I am aware of the capability to do this with data mesh.
However, how do I ensure that data shuttle does not create a new excel file, but rather updates a specific file?
Do you have any experience with this? they only allow me to select folder upon where to place the new excel, but I cannot select a file.
It will create a new file the first time you run it, but subsequent runs will only update the original file you create. If it is crucial to leave this updating data in an existing Excel file you already have in place, you could:
Hope that helps!
Dear All: Good morning. We are VERY close to getting the approval from my top management for DataMesh - this is something I have been hoping to get for us since 2019. We were able to help 4 departments set up and become power users of Smartsheet last year. DataMesh will allow easier and faster inter-departmental data…
Can Document Builder be automated so that after a form is filled out the document is automatically created and sent to the person who filled out the form (or any other identified person)?
I have a DataShuttle workflow where users attach a spreadsheet to an intake sheet. Question1: If multiple spreadsheets are attached to the intake sheet (via a form) does the DataShuttle workflow queue up these attachment imports? Question2: If you have to attach a spreadsheet and wait until the workflow completes, how does…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.