-
Importing all columns from MS Project
I have an MSP plan that contains financial information. When I import in to Smartsheet it does not import these columns. I have tried exporting to xml then importing but get the same issue. Is there a simple way to import all columns from an MSP file into Smartsheet? Am I missing something?
-
Import from .mpp file not perfect?
Recently have been testing out functionality within Smartsheet to compare to other products that are very similar and there seems to be a critical issue with the import functionality from MS Project .mpp files. See below from the same .mpp file: PCH-36 should be a parent on the same level as ASC/OQR, the section is…
-
Which Fields are imported from MS Project?
Hello - Can someone please enlighten me as to exactly which fields are imported from MS Project into SmartSheet? As far as I can tell, the (non-custom) following fields get automatically imported: -Task Name -% Complete -Duration -Start (to "Start Date') -Finish (to "End Date") -Predecessors -Resource Names (to "Assigned…
-
Smartsheet PDF Exports Break Links Over One Line?
I am having an odd issue in using Smartsheet and exporting Reports for the first time. I created a report from one of my sheets, with one column that includes a hyperlink. It's a pretty long link, but the text is wrapped so it simply splits the link up with a line break in the export. However, the actual HYPERLINK that it…
-
Export to Excel to include reference to attachments
When a Sheet is currently exported to Excel, there is no reference to any attachments that may have resided in the Sheet. As a minimum, it would be good to have a column in the XLSX that displays the name of the attachments included in each row.
-
Keeping Formulas When Downloading to Excel
Hello, I found online that it says when you download a sheet into an Excel sheet that it does not keep the formulas as they are different. Now just in case, I thought I'd ask: Is there a work around for this at all? Is there absolutely no way to keep your formulas when you transfer them to an Excel?
-
Function to allow the import/export of multiple filters
If we'd be able to export/import filters to be able to share between users this would be an awesome feature that would greatly benefit our office. We have many people looking at the same Sheet but currently if we want to set up filters each user has to create them from scratch. I would think this could be an easy feature…
-
Import Data from Database
Good day, I am looking for a solution that will allow me to automatically populate a Process Owner column in Smartsheet from an Oracle table (for example). From what I have been able to find, the Live Data Connector is not capable of importing data from a Database to Smartsheet (It can go the other way, which in this case,…
-
Forms: How to print/generate a PDF with field label and answers
I am creating a survey form, and the questions are quite long. There is a character limit for the column/field name, so I just use numbers (e.g. "question 1", "question 2") in the column/field name and put the actual questions in the field label. That seems to work for the form. However, I want to be able to print/generate…
-
Newline for Mapping
Hello! I have been creating a sheet that pulls data from a hotel database and then maps it into a pdf. I have been trying to get the sheet to pull as many suitable (in this case, from the same town) hotels as possible. The only way that I have been able to do this is by using =JOIN(COLLECT({Hotel Database Name Range},…
