-
Data shuttle adding leading Zeros
When uploading data with Data shuttle it has started adding leading zeros to columns that contain numbers so they are being read as strings instead of numbers and can no longer be used in formulas. Is anyone experiencing this issue or have a solution. The problem started occurring this week and I have not experienced it…
-
Ability to See Integration and App Users
Smartsheet has come out with many great integrations and enhancement modules that our teams use. However, many of those are tied to a user and must be manually recreated or transferred to another owner if that user leaves the org. Or, an integration may be running but others don't know about it and it can break from the…
-
DataShuttle adding values as strings
Hello, DataShuttle has started inputting values via upload workflows as strings rather than numbers. The source data is in normal number format, but when uploaded into Smartsheet they have a ' in front of them. This has only started occurring this week and was working normally before.
-
Data Shuttle Formatting for Multi Select Fields
In a world that looks at automations and limit human intervention to reduce risk and resources, the standardization of how data is imported and exported through Data Shuttle is inconsistent forcing human intervention as a work around. It would be helpful if the export/offload of multi select fields through Data Shuttle can…
-
Using Data Shuttle to take a Multi Select Dropdown to Update a Dropdown on Different Sheet
I have done some research and testing around using data shuttle to update dropdown fields. Essentially I want to take what a user selects from a multi select dropdown source sheet to update a field on a target sheet so that only the options they can see in the dropdown are what was selected on the source sheet. I'm able to…
-
Data Shuttle Changing 100% to 1%
When using Data Shuttle to import data from an .xlsx sheet, the decimals from that sheet that equal 100% are instead converted to 1% in Smartsheet. This issue is the same as in this Community post that has no answer or resolution: https://community.smartsheet.com/discussion/90205/data-shuttle-changing-my-100-to-1 The…
-
Clear a Sheet on a Schedule
Hello lovely community, I need some help figuring out the best mechanism for clearing a sheet on a schedule. It really should be easier than this! I have tried the following methods, and outlined the limitations and issues below. I would LOVE to get some suggestions for other methods! Problem: I need to fully clear (delete…
-
Importing Dates
I am importing a manufacturer's shipping report into Smartsheet with Data Shuttle. If the product has not shipped, the manufacture has a date of 00/00/0000. When I import the data, I want the date to be blank, if the date equals 00/00/0000. How can I make the cell blank if it the date imported is 00/00/0000 ??
-
Merged: Data Shuttle: Export to Multiple Smartsheets
This discussion has been merged.
-
Ran workflow - sheet remains blank, data not pulled from most recent attachment
I am trying to create a workflow that will merge data/adds rows when a new file is attached but every time I run the workflow, the sheet remains blank. After I attached the file, I deleted the data to ensure the workflow was working properly. See the steps I followed below. I have tried both options listed for 'source…