Importing and Exporting
Discussion List
-
Adding Matching Barcodes/SKU's from a transfer sheet onto a master Inventory sheetIn Using SmartsheetHello all, I'm new to smartsheets and working on setting up a barcode based inventory management system for the warehouse I run. I feel like I have the transfer sheet up and running just need to get all of that information to condense ont…
-
Integrate with Microsoft AccessIn Apps, Integrations, and Add OnsDoes Smartsheet allow for integration with Access database tables? Is this something that a connector is needed for; such as Data Uploader? Will the integration work with older editions of Access or only Microsoft 365?
-
Mass file transfer from One Drive folders to Smartsheet AttachmentsIn Apps, Integrations, and Add OnsHello, I'm wondering if this is possible through the One Drive connector, any automation tool, or API. I have roughly ~1,000 folders in OneDrive, and the folders are named by client ID. Each client has 1 row in a smartsheet tracker, and t…Accepted Answer 82 views 6 comments 0 points Most recent by Etienne Mermillod Apps, Integrations, and Add Ons
-
Smartsheet - Azure DevOps integrationIn Apps, Integrations, and Add OnsHey guys, I'm trying to create a connection between Azure DevOps and Smartsheet but I'm having a lot of issues with it. Has anyone ever made a two-way connection between the two? Especially being able to update an item in Azure when a ro…Answered - Pending Review 76 views 1 comment 0 points Most recent by Genevieve P. Apps, Integrations, and Add Ons
-
Ability to amend 'sent from' email address to personal email for "Email Shared Users"In Using SmartsheetRegular update notifications are being sent to the Shared Users of a very busy Smartsheet. As such, our client has requested any emails that require immediate attention (not just standard updates) be sent from a personal email account, no…
-
Is there a way to migrate external references?In Using SmartsheetIs there a way to migrate external references from one sheet to another from the 'Sheet Reference Manager' (Right Click Cell -- Manage References... -- Cross Sheet References)? Or would it be a manual task to create references again. Thank…
-
Is it possible to automate export of specific cells on a triggered event?In Using SmartsheetWhen our "Completed" column is checkmarked, we wish to export that row and its children rows to an external file such as .csv, Excel, or Google Sheets. If possible, we would also like to export the attachments for those rows as w…
-
Loading data from excel into Smartsheet API to an existing sheetIn API & DevelopersI have data in Excel which I have loaded and cleaned in Python and I want to load the same into Smartsheet through API. This data goes into the existing sheet in Smartsheet, which is typically adding new data into the sheet. I have gone th…
-
Merge data from Smartsheet in Microsoft Word DocumentIn Using SmartsheetHello, I have been able to merge data from a smartsheet into a Google Doc Template using the smartsheet merge add-on. Works great. But, is it also possible to do the same thing but then in a Microsoft Word Document ? I have been asked…
-
Can a smartsheet form autopopulate a PDF? Or can you push every row to a recreation of the form (inIn Using SmartsheetHi, We are using forms to gather group ideas for creative projects. After, we would like to take each form submission or row and populate to a formatted PDF that can be presented to the managers for approval. Is there a way to push a form…
