-
Shuttle data: A whole column from one smartsheet (preferably filtered) to a new smartsheet
Hello Im having trouble.. I have a SourceSheet that im not admin to.. where from i want new rows of a certain column to continously be added to MyOwnSheet Ive set up a offload, and when i create the complementing upload data shuttle i cannot find the file that i believe is suposed to be created during offloading.. I first…
-
Extract a Text String to Remove Unwanted Text from Jira Connector Ticket "Summary"
Situation: I have a SmartSheet utilized for Epic tracking of project deliveries. I use Grid and Gantt Views. These sheets are typically 50+ rows long with linked tickets under Jira Epics. Background: My Jira Ticket Summaries (ticket titles) are consistent and long for SOP purposes. Ex: "ABC-DEF | Client | Q3 August 2024 |…
-
Error! Unable to parse request. (1008)
Build Pivot Table Preview works fine, but get this error when I create.
-
Data Shuttle source stuck on loading external account
I am trying to connect Data Shuttle to my OneDrive but it is stuck saying "Loading…" I have let it load for a while and it seems to never change. Any ideas as to why this is?
-
Freshservice ticketing integration with Smartsheet
Has anyone integrated FreshService ticketing with Smartsheet? We are looking to automatically create a ticket link when onboarding new employees. The goal is when a form is submitted it automatically creates a link to Freshservice, someone from HR would then be able to click on the link in the dashboard if they want to see…
-
WorkApps - automatically add users to "roles" based on a form being filled in
Hi, We have a database of folks, we want to be able to assign their role in the Smartsheet - and have the person added to that role in the associated WorkApp. So, for example in a list of 200 folks, there are 20 managers, 5 admins, 15 department coordinators and the rest are generic users. Rather than manually adding the…
-
Bridge list sheets shared with specific user across entire Smartsheet account
How would I go about creating an API Call to identify the list of sheets shared with a specific user (not me)? Background: I am the system admin of our Smartsheet account, but we have a unique situation where we're sending data outbound via API to a system in which our company has developed internally. Their API is pulling…
-
Data Shuttle Offload Error
Hello! Hope everyone is safe and sound. Since yesterday, I´ve been having troubles with my offload workflows, all of the 23 offloads (except 1) have been failing to run and reports this error: "Workflow Execute: A required header was missing or invalid: Content-Length" I´ve been trying to figure out the reason by deleting…
-
Control Center cell link back to source sheet
I have a Blueprint setup in Control Center for provisioning project sheets/reports/dashboards once a project is approved. What I can't figure out how to do, is to link a status cell from the newly provisioned project sheet back to the source intake sheet for at-a-glance monitoring across all projects. Is this possible?
-
Automation Advice and Data Shuttle
Background: I am creating a database to track employees working on construction sites. I need to track movement between sites, and receive reports in Excel with crew information on a weekly basis. I need to record the date that an employee's location changes. For example, if someone works at site X for 6 months and then…
