Product questions?
Ask it here! The community's got your back.
Discussion List
Data Shuttle issue
This discussion was created from comments split from: Error Message on Offload workflow in Data Shuttle.
Task Sheet Global Update
I have updated my "health" column in my task sheet with new formulas and new symbols. I am trying to figure out how to update all my existing projects to have the same symbols and formulas by doing a global update. I chose "find and replace" then my task sheet. What should I enter as my find string?
Jira Connector Workflow is not bringing over Jira System populated fields or Jira Formula fields
Hi! I have two fields that are not coming over in my sheet from Jira. One is a field that is generated by the system when it looks at the status of related tickets that are not directly in the project that I'm linking in the workflow The second is a column that is a formula in Jira that calculates a weighted score based on…
Data Shuttle is not finding all columns in the source sheet
I am trying to use data shuttle to upload data from an excel file in SharePoint but when I get to the mapping part, the column names are completely different from the source. Almost as if it is not pulling the data from the sheet I specified, but a different one. I am using the second tab of the excel sheet and some of the…
Data Shuttle - trigger from email to sheet
I have a sheet that I currently update using a CSV file that is emailed to me weekly. I set-up a Data Shuttle to run upon attachment that works great. But I'm trying to remove a step. Is there a way to email an attachment to a specific sheet that would then trigger the Data Shuttle so I don't have to manually upload each…
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…
Time format data change after uploading data to smartsheet from excel via Data Shuttle.
I am using data shuttle to upload data from local .xlsx file. Below is the data available in .xlsx file in "hh:mm" format. After uploading data to smartsheet by data shuttle, The value is changed and showing in below format. .xlsx file is generating from system automatically so i can not change or add any filled in .xlsx…
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…
