-
Export/Archive
Hi! I would like to know if it's possible to take my sheets and export (including attachments) into a zip file so that I can save in Sharepoint? I found I can export using data shuttle (or just to excel) to put in Sharepoint, however, I cant figure out how to also download the attachments saved on the sheet without doing…
-
Export PDFs of multiple rows at once?
Is it possible to export PDFs of multiple rows at once? I always go on the three dots in the row, click on "Print" and then save as PDF to export a PDF of my row. Is it possible to generate multiple of these documents at once?
-
Relational Smartsheets
I would love to be able to connect sheets via a unique ID that is common to the sheets. Making sheets relational would be very helpful because we could have multiple related sheets, and avoid having to add common fields across all sheets. I'm maturing a program using SS, and if I had the ability to relate sheets it would…
-
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 ?