-
Get started with Control Center, Dynamic View and Data Shuttle!
Want to learn more about how to streamline and scale your work with Smartsheet? Check out the resources below for how to get started using these Advance capabilities: Control Center: Accelerate your organization's work at scale with repeatable, reliable, and impactful project execution. Access Control Center and sign in…
-
Create new rows in Sheet2 as soon as a column is updated in Sheet1
Hi Team, I am facing a unique problem and unable to find a direct solve for it. Seeking help from the forum here. I have a sheet [lets say Sheet1], with 30 columns, out of which there is a multi-select dropdown column [say 'Impacted_Countries' with all countries listed]. When the row is initially created, this column will…
-
Data Shuttle upload using CSV files on a Google Drive
Hi, I hope someone can tell me what I'm doing wrong. I'm trying to use Data Shuttle to upload data from CSV files stored in a Google Drive folder. The CSV files are updated by batch jobs which do NOT change the filename or the file ID. Data Shuttle shows the workflows completing successfully (green check next to the…
-
Data Shuttle - Delay in adding line to Target sheet
I have experienced a line of data that was submitted on 8/07/2023 show up on the target sheet on 5/24/2024. I am looking in to see if anyone else has experienced this and what could be causing this delay in the line being added to a target sheet. I have seen others in the past add to target sheet within 24 hours, but this…
-
Work around for Data Shuttle not recognizing identical data
Hello! This is pretty hard to explain but I am hoping someone can help me with this dilemma: I am using Smartsheet to build a tracking system that monitors where field project workers are showing up on a weekly basis. I get the job addresses as a spreadsheet from another department. Since I am working with hundreds of…
-
Data Shuttle Failing "Workflow Execute: Could not access source"
I have a Data Shuttle automation to pull in an Excel file to a sheet (replace) on a weekly basis that lives on Sharepoint. Every time the automation runs, I get the error message "Workflow Execute: Could not access source. Please check your workflow configuration for errors." The Excel file will also not be hyperlinked…
-
Pharmaceutical Life Cycle Management
Hello, my name is Louis and I work in Life Cycle Management for a rare disease pharmaceutical company. In my role, I use Smartsheet to translate the impact of project activity on our commercial products to the supply chain business. We detail project milestones, regulatory strategies and product demand to visualise…
-
Data Table constant error, "An Internal error occurred. Connection will refresh on next execution"
I have a Data Table linked to a sheet that gives a constant error (above), and will not work no matter how many times I rebuild it. There are no numbers with special characters, and the dataset is pretty standard stuff. I can't find any info at all on Data Table errors, and this has been going on for 24-hours. I used Data…
-
Data Shuttle Last Run Date and Timestamp
Please show the actual date/time rather than a relative Last Run Days/Hours/Minutes Ago. This would make it easier to do troubleshooting, especially with Data Shuttles that are scheduled to run more than once per hour.
-
Simultaneous Update of Project and Review Sheets, for Non-Existent Projects, with one form
I am part of a Solution Architecture department that uses Smartsheet to track project reviews. Our workflow involves two Smartsheet sheets: a Master sheet for basic project information (project name, ID, contacts, status), and a Review sheet for detailed review data (review ID, review name, review type, project name, and…
