Product questions?
Ask it here! The community's got your back.
Discussion List
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…
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 |…
