-
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…
-
Import Date column to google doc with my formate
I added Smartsheet add-on/plugin to Google Doc . The DEFAULT column formate in smartsheet is the formate imported to google doc ( ex 23/07/22) even if i change date formate in smartsheet to other formates of my preference stilll the default formate is imported :( Is there a way to import my preferrable date formate…
-
Workflow from Harvest
Hi, I have time logs being imported from Harvest from multiple projects, I then want to split this data again using workflows into separate sheets with relation to a specific project. Eventually I want to roll this out between a team of people (around 10 people). Is this possible as I have other workflows that work fine,…