-
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…
-
Issue with Smartsheet Cell Limit - Data Shuttle
I'm trying to use Data Shuttle to import data into a Sheet upon attachment of an Excel workbook to the same sheet. When I attempt to run this Data Shuttle, I am getting an error that I have exceeded the 500,000 cell limit. The parameters of my source Excel sheet are as follows: Cells: 401,668 Columns: 40 Rows: 10,280 I…
-
Automatically linking different sheets to a master sheet?
Hi, I am trying to create a master sheet with information I need that pulls specific cell data from multiple different project sheets. I know I can use vlookup's and reference another sheet within them but I'm wondering if there is any way to create a template or workflow so that when a new project is added to the projects…
-
Including CONTACTS in the Excel import
I have a list of records that I need users to review and update, but they only need to see the records assigned to their user account. But as soon as I import the file into Smartsheet, the column of usernames (contacts) is listed as text, not as CONTACTS (Smartsheet users). How can I fix this? I want to use the usernames…
