-
How do I avoid an export to Excel combining multiple cell values into one?
I have a sheet that contains cells that are populated from a multi-select drop-down. Many of those cells contain two or three separate values. When I export the sheet data to Excel, those multiple values get combined into a single value. For example: A cell in the sheet contains three category values: Content labeling,…
-
Missing columns on XML export of Gantt chart
I have several columns I need to export with my Gantt chart but only the standard Gantt columns seem to export. Every new column I added to the Gantt chart does not export. I even re-loaded the XML back into Smartsheet and the data is missing. Really need this to work to tie into a portfolio management tool the company is…
-
Different font in Gannt header exported to PDF
Anyone else seen this? Not sure if it has been like this since the start or if its a new thing... Is there a setting to correct this?
-
Integration with Power BI
Hi, I'm trying to link my data to Power BI in order to analyse it. Dos anyone know whether or not changing the formatting of data in Power BI would also change the format within Smartsheet? I assume not but thought best to check first? Cheers
-
Cell values export from one project to another
Hello, We are currently managing a construction project with smartsheet and have created a Gantt Diagram and a few Dashboard to monitor several KPIs. The dashboards are updated automatically with every changes in the master project and provide up-to-date information during meeting. I would like to add curves to the…
-
Import to smartsheet is unable to auto-assign tasks - any plans to address this?
Dear 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 addresses * The specific problem is that even though the name or email address values in the file…
-
Hyperlinks not exporting in excel
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?
-
Export into Excel and PDF not capturing all of the data
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 document of various sheets and I go in everyday and export a report. Today content is going missing.…
-
PDF exporting
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 preview. I have column wrapping turned on for some - these should tend to be narrower than…
-
Connect MS Power Query to 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 able to figure out how to access my content through Smartsheet and manage the data.…