-
Datatable - Ability To Setup Which Sheets to Pull Data From Instead of Offload and Upload?
I'm trying to setup a datatable to collect from a few sheets and I see that I can create the datatable from offloading the sheets with the data and then uploading the sheets into the datatable. However, is there an easier way? It'd be much easier if I could just select which sheets to pull the data from for the datatable…
-
Exporting a filtered view
Hi all Do you know if there's a way to export a filtered view of a smartsheet? When i try doing it it exports the entire sheet instead of my filtered view.
-
Indenting Text for Dashboard Exports
Hey Smartsheet Community! I am posting this in response to the Engage Product Vision sessions that Ben Canning hosted, where there was some talk about someday exporting dashboard content other mediums such as PDF, Powerpoint, Google Slides, etc. In my company's change management journey we have been working hard to…
-
Image import from Excel/Sheets
When importing a spreadsheet from Excel or from Google Sheets, it would be SO helpful to have embedded/pasted images come into the new smartsheet as attached images. Use example: Users copy/paste screenshots into a Google Sheet being used as a bug tracker, because Google Sheets makes it very easy to do, but then they're…
-
Export MS project plan to excel and import Smarthsheet
Hello Wondering if someone can help me with importing MS Project plans into smartsheet. I am having problems with importing MS project plans into Smartsheet. it is loosing predecessors. I read that exporting the MS Project plan to excel and then importing the excel file into Smartsheet. However, when I do that the excel…
-
Linking an Excel cell to Smartsheet a cell
Dears, I would like to collect status updates from test scripts created and used in Excel and present it in Smartsheet. All test scripts in Excel have one cell indicating the percentage completion level of the test script. Objective is to link that one cell to Smartsheet sheet where I present the list of all test scripts…
-
Whats the most reliable way to automate data collection by student/client name?
I'm pretty new to Smartsheet and I have a pretty big set of data for each one of my 60-80 students I am trying to use it to track. I manage a therapy department at a special ed school. I have two sheets one that gets raw data from a form filled out by multiple therapists for between 60-80 different students and another…
-
Data Shuttle Export - Inconsistent output for checkbox field
When using Data Shuttle my checkbox fields that are actually checked, do show up as "True" in Excel. However, the unchecked fields sometimes display a "False" value, while most of the unchecked fields appear as "null". Is there a fix for this? Is there a way to either force all unchecked to be either null, or false? One or…
-
Deleted Rows
RIGHT NOW: Implement a pop-up warning to alert someone and verify that they want to delete a row. You do it for unlocking rows, and that's nothing compared to deleting a row. SOON: Give us a new user level with edit access but no ability to delete rows or make it impossible to delete a row if any cell in that row is locked…
-
Data Shuttle Kicked off by Power Automate Flow
I am using a Power Automate Flow to create an .xlsx file and then run an Office Script on it. This is done within 1 flow in Power Automate. The file is saved to One Drive. Currently I have a Data Shuttle that I run manually to take the updated file and load to Smartsheet. Is there a way to use Power Automate to run the…
