-
Hiding sensitive data from users due to access being required to underlying datasheets
So I ran into a challenge while trying to create a vacation request process using smartsheet. Yes, a bit of HR within smartsheet. Not ideal, but possible. The challenge is that people need to have read access to the underlying sheet to be able to see data in reports and dashboards. This is obviously not allowed due to the…
-
Individual dates integrated into Outlook
I have sheets with multiple date columns (start date, end date, and then some supervisor check-in dates in the middle of the date range), and I'd like my Outlook calendar to show these events as individual dates, rather than getting lost in the date range.
-
Looking for ideas to improve my current daily process re: managing references
Hi all, This is a very open question to see if I can get ideas from the community to improve my daily morning process with Smartsheet. Apologies for the lengthy question- this is outside of my usual very specific help request. I'm responsible for our Company's data; in the property insurance- independent adjusting world.…
-
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…
