-
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…
-
import and consolidate daily changed excel file with SS sheet
Hi, currently my team (4 members) uses one excel file to save information about insurance incidents (task tracking with regularly action documentation f.e. what have craftsmen done, has insurance paid a.s.o). It takes a few month until we all may use SmartSheet. Until that time I would like to daily or weekly import the…