Importing and Exporting

Discussion List

  • Hyperlinks not exporting in excel
    In Using Smartsheet
    I 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?
    26 4
    26 views 4 comments Most recent by Andrée Starå Using Smartsheet
  • Export into Excel and PDF not capturing all of the data
    In Using Smartsheet
    Hi, 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…
    83 1
    83 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • PDF exporting
    In Archived 2015 Posts
    I 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…
    498 2
    Closed 498 views 2 comments Most recent by hopek Archived 2015 Posts
  • Connect MS Power Query to Smartsheet?
    In Using Smartsheet
    Can 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 …
    351 2
    351 views 2 comments Most recent by JDupes Using Smartsheet
  • Creating a PMO functionality
    In Formulas and Functions
    I 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…
    76 1
    76 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Hyperlinks not exporting
    In Using Smartsheet
    I 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…
    51 2
    51 views 2 comments Most recent by Kara Lumley Using Smartsheet
  • Index / Match Multiple columns from another sheet
    In Formulas and Functions
    I 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 …
    594 3
    594 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Taking a dashboard "snapshot" as a pdf and attaching to a given row
    In Formulas and Functions
    While 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 …
    626 5
    626 views 5 comments Most recent by Andrée Starå Formulas and Functions
  • export schedule to XML, the dates got moved
    In Using Smartsheet
    Hi 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  
    72 1
    72 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • Export a report and include cell images
    In Using Smartsheet
    Hey Guys, Unsure if this has been raised before but I am trying to export a report to PDF and include an image currently added to a cell in the original sheet. If I export the sheet I can see the image but not when exporting the report. …
    213 3
    213 views 3 comments Most recent by Andrée Starå Using Smartsheet