Importing and Exporting
Discussion List
-
Import to smartsheet is unable to auto-assign tasks - any plans to address this?In API & DevelopersDear Smartsheet, The issue - import of a google/excel sheet containing an "Assigned To" column fails to assign to known smartsheet users any of the tasks listed in the file that was imported with matching user names/email addre…
-
Hyperlinks not exporting in excelIn Using SmartsheetI am having an issue where my hyperlinks are not exporting to excel. This is something I have been using for months and just noticed it not working today. Is there a setting that has changed?
-
Export into Excel and PDF not capturing all of the dataIn Using SmartsheetHi, this is my first time posting. Hopefully this is not a duplicate of another posting. I just ran into a problem this morning with "What you see is what you get" is not consistent in exporting a document. I have a roll-up doc…
-
PDF exportingIn Archived 2015 PostsI find that I can only select columns I want to put to PDF if i have gantt charts on. I want to export a nice PDF w/o a chart yet still select columns. I would like to be able to MANUALLY determine the width of columns in a print pr…
-
Connect MS Power Query to Smartsheet?In Using SmartsheetCan anyone explain how to connect Smartsheet reports to MS Power Query? I have tried creating API Tokens to connect some of my reporting, but I’ve been unsuccessful. I can “halfway” Access the Smartsheet via Power Query, but I’ve not been …
-
Creating a PMO functionalityIn Formulas and FunctionsI have just been assigned the task of setting up the Project Management Office in my company. For now I need two things, firstly a project tracker for tracking and monitoring individual projects and then a master portfolio tracker where al…
-
Hyperlinks not exportingIn Using SmartsheetI am trying to export my smartsheet to excel and whenever I do this, all the hyperlinks are gone and I have to enter the hyperlinks again manually in the generated excel spreadsheet. I tried exporting to google docs and the same issue. Hyp…
-
Index / Match Multiple columns from another sheetIn Formulas and FunctionsI tried to use index/match to reference multiple columns from a resource sheet. I can't seem to get the formula correct. My table (resource) has a list of teams with start times, parking information, notes, etc. The table includes all the …
-
Taking a dashboard "snapshot" as a pdf and attaching to a given rowIn Formulas and FunctionsWhile the header of my question seems confusing, hopefully an easy solution exists somewhere. I have a complex smartsheet's dashboard created which has metric widgets filled with values that update every time a new form is submitted to …
-
export schedule to XML, the dates got movedIn Using SmartsheetHi There, When I export schedule from Smartsheet to XML file and open XML file in Microsoft project, the dates of some tasks got moved. Has anybody had the same problems and possible ways to fix it? Dale Dai
