-
Import Excel to existing Smartsheet & keep existing smartsheet columns
I've been copying/pasting excel data into an existing smartsheet. It's not a lot of rows but I have column formulas in smartsheet that I want to keep. If I import the excel to my existing that has 10 columns but my smartsheet has 15 columns (5 are the formula columns) is there a way to keep these 5 columns while importing…
-
Smartsheet XML export to P6 Import
I am trying to import into P6 the XML file from Smartsheet. The fields do not map correctly, for example start date maps to baseline start date. Also, Assigned Field in Smartsheet does not seem to map into P6 at all. I am working with 2 Smartsheets developed and owned by others. I am trying to use the Smartsheet info in a…
-
IDEA: Auto-Populate New Users' Profile info from Outlook GAL or OKTA, OR Import info into contact
Please make it possible to Sync the Personal Settings>Profile details with an outside service, such as Outlook 365 Global Address List (Admin), OKTA, etc, so that the settings below are automatically populated. Since users will likely want to update the data or fill-in missing data, we'd only want it to pull the data into…
-
Exporting/Sharing Filtered and Indented Sheet View
I'm looking to find a way to share a filtered view of a project with a supplier. I would like to either share a live view or schedule sending an updated version of the project plan weekly. The issue I'm running into is that there doesn't seem to be a way to to do this in a way that the rows are both filtered and indented.…
-
Problem when trying to import Excel Worksheet
I'm getting very frustrated. I right click on "Sheets", select "create", then "import Microsoft excel…". Then I find my file and open it, I'm asked if to import settings, and I press import and then…..I get this message EVERY TIME…."The workspace you are trying to modify is currently not available. It may have been…
-
How do I mass export sheet data from smartsheets
hello, I am about to cancel my Smartsheet subscription, and I'm wondering the best way to download all of my data prior to canceling? Seems very cumbersome to download one sheet, or one folder at a time. Can I download an entire workspace? thank you
-
Merged: Customizeable Gantt Headers
This discussion has been merged.
-
Improved PDF Exporting of Dashboards
I have created a dashboard that I would like to export to PDF to share to people that do not necessarily have Smartsheet and more importantly don't want to open links/attachments to get "quick glance" data. When I print as PDF I loose a lot of formatting and can't centre the data across the page. without customising…
-
Data Shuttle: update a checkbox in the source sheet to indicate success
Currently, Data Shuttle efficiently migrates data from Smartsheet to SharePoint, OneDrive, GoogleDrive, Box, & as a Smartsheet Attachment. This Providing a seamless integration between the two platforms. However, one aspect that could enhance user experience and workflow efficiency is the ability for Data Shuttle to…
-
Batch uploading to drawing register
We use smartsheet for our drawing registers but are having to upload each drawing individually. Is there a way to upload drawings in batches and each one automatically upload to a different row. It is very long winded at the moment the way we are doing it, especially when then having to input the relevant drawing numbers…