Importing and Exporting
Discussion List
-
Importing Excel Data into a templateIn Using SmartsheetI have created a template with all of the appropriate columns, workflows and filters that I need. I have a 4900 row Excel spreadsheet with my data. I would like to import the Excel spreadsheet into my template. I can copy and paste, but si…
-
Converting project links from report to hyperlink in Power BIIn Using SmartsheetI have a report that I am using to feed into a Power BI file. There's a column in the report for a link to individual project sheets, but this column shows up at text only in Power BI (For example, a clickable hyperlink to "Sheet A&q…
-
Newline for MappingIn Formulas and FunctionsHello! I have been creating a sheet that pulls data from a hotel database and then maps it into a pdf. I have been trying to get the sheet to pull as many suitable (in this case, from the same town) hotels as possible. The only way that…Answered - Pending Review 38 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Jira Connector only allowing one project to one sheetIn Apps, Integrations, and Add OnsHi, 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 Apps, Integrations, and Add OnsThe 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 …
-
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 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?