Importing and Exporting
Discussion List
-
Jira Connector only allowing one project to one sheetIn Premium Apps and IntegrationsHi, We have recently implemented the Jira connector for Smartsheet and this is working well in each sheet where we have a one to one relationship with Jira Projects. We have a single sheet which is collating all enhancement requests (usi…
-
automate a download of a sheetIn Using SmartsheetDear Community: Please be gentle...I am new to the community. Our application uses forms to have people add row to various sheets. On one of the sheets we need to upload to one of 1000 systems as people continue to add to the sheets. I …
-
Integrate with Outlook with Dates and Times and Assignee InformationIn Premium Apps and IntegrationsThe outlook integration as it exists is nice if you only have one or two projects. As a single user I manage hundreds of projects at a time I would like to be able to sync my calendar to outlook in a more integrated format. For example,…
-
Export selected rows only to excelIn Using SmartsheetHello, is it possible to export only the filtered rows to excel? When doing the export, it will hide the rows that were filtered, but they will still be in the excel so if I try to copy and paste or create a mailmerge, the excel will also …
-
Export Smartsheet attachments to OneDriveIn Premium Apps and IntegrationsHi! I'm using Smartsheet to gather information through forms. People fill in a form, they add a picture in the submission, and all this gets saved in a sheet. Eventually, I receive rows filled with information in Smartsheet and for each r…Answered - Pending Review 61 views 7 comments 0 points Most recent by Andrée Starå Premium Apps and Integrations
-
Excel ImportIn Using SmartsheetWhat are the prerequisites for importing an Excel spreadsheet into a new sheet. I read number of columns, size and row constraints, which my Excel spreadsheet meets. I am getting a warning regarding fields cannot be more than 50 characte…Answered - Pending Review 213 views 3 comments 0 points Most recent by Andrée Starå Using Smartsheet
-
Import Excel file and include embedded imagesIn Using SmartsheetHi, I was not able to find a way to import an Excel file that has images embedded in cells, and keep those images when the import in complete. Is that possible? Am I missing something? Or do I have to re-import those images manually,…
-
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 Premium Apps and IntegrationsDoes 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 Premium Apps and IntegrationsHello, 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 61 views 6 comments 0 points Most recent by Etienne Mermillod Premium Apps and Integrations
