Product questions?
Ask it here! The community's got your back.
Discussion List
Data Shuttle Merge and Append Master Sheet
Hi all, hoping someone can clear up a misunderstanding or provide a workaround here. I have a number of 'sub-sheets' that I would like to merge into a Master Sheet. They are all the same format have the same columns and have a common key column that can be referred to when SS is working out whether to add a new row or…
Data Shuttle not bringing in column as a number
I have a data shuttle to bring in a csv with numbers and dates. There is one column that is a number (formatted as a number in excel) that populates a column in SS that is a text/number column. I have a formula that uses this column but it does not work because DS is not bringing the data in as a number. I have tried…
Delete Rows using Data Shuttle Offload
I need to automatically delete rows. I set up an Offload workflow in Data Shuttle and the rows I wanted deleted are there, but they are also still in my source sheet.
How to use Data Shuttle to add rows without erasing changes made to target sheet?
I am using Data Shuttle to transfer a sheet of individual people activity from a source sheet to a target sheet. I want to be able to add notes to the target sheet or check boxes in columns that are on the target sheet and not the source sheet. I set up DS to merge data into the target based on a key column value. Each…
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…
