-
Format report as a form; export to Word
I would like to be able to use SS as a repository for data that can then be output through a form and imported into a Word document as formatted text, using Word style assignments.
-
Can I link a Smartsheet cell to a cell in Excel?
Is there a way to make links from Smartsheet to and Excel file? If so what is the best way to do this?
-
Error 1008...
Hi Everyone, Ive been trying to automate a couple of imports to our smartsheet. Long story short, it is a JS script that takes a xlsx file extract taa from it and exports it to smartsheets. TBH ive been working on this project on and off for at least 4 months. As of now, the latest error im getting is this: Error adding…
-
Can we paste "plain text" from Excel rather than Text/Number?
When we create a new column in Smartsheet we only have the choice of Text/Number and not just "text". In Excel we have data that is numbers that are plain text. So in Excel we have things like: 3.50 3.51 3.51.0, 3.51.1, etc. But when we import this into Smartsheet we get: 3.5 (a rounded off number), 3.51 (a number) 3.51.0…
-
How to combine multiple sheets with large volume of data
I have a large data set (9K rows + 250 columns) so it is broken up into multiple worksheets. Is there a way to combine? I have figured out how to build reports on multiple sheets, but not how to compile the results for a dashboard (ex: count how many records are across all sheets and have this on dashboard with a breakdown…
-
Imported Hyperlink Text
We have a project management software that generates the above text representing a job location. We import the text to smartsheet though data shuttle so we can distribute dispatch information to our 300 employees. My problem is that the import works as shown above where the URL is incomplete due I'm guessing to the comma…
-
Hyperlinks do not work when sheet is exported
Hyperlinks for sheets do not work, when the sheet is exported to a pdf. However it does work when exported to excel. Any reason for this ?
-
Built in code to sustain Excel project plan hierarchy
When importing Excel project plans into SmartSheet, indentations used for parent/child task relationships need to be maintained. There is a lot of rework otherwise. Thank you!
-
Problem with Data Shuttle that is not accepting xlsx files?
Hi All, Anyone experienced problems with Data Shuttle that it is suddenly not accepting the xlsx files from One Drive anymore? From my side when I open the file itself the section "Protect/Unprotect" sheet under Review is greyed out. Could it be that this is due to Microsoft Information Protection that I'm not able anymore…
-
Error When Importing Google Sheet
I was able to import this sheet successfully once as a test. Now when I try to import I get the attached error that states that the Excel file is invalid, but I didn't select to import and excel file! Any help would be appreciated!
