-
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.…
-
Creating a PMO functionality
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 all the info that's updated in the individual trackers feed into. This master tracker…
-
Hyperlinks not exporting
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. Hyperlinks are not exporting. Why? Please assist. When I tried to log into the…
-
Index / Match Multiple columns from another sheet
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 team information. When I add a name to the new sheet, I assign that name to a team.…
-
Taking a dashboard "snapshot" as a pdf and attaching to a given row
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 a sheet ("sheetX" for later reference). What I want to do is try and capture a part (or…
-
export schedule to XML, the dates got moved
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
-
Worksheet with more than 20 sheets cannot be imported
If Smartsheet only imports the first sheet in a workbook, why does it care how many other sheets there are??
-
Export Dashboards
Hi All, I really need to export my reports and dashboards and the PDF option is too limited. After exporting to PDF and then using a program to convert to PowerPoint or Word, the quality is not the same. We as a company would strongly recommend the option to export reports and dashboards (Word, PowerPoint, etc.) directly…
