-
How to prevent data shuttle from converting excel text to number
An excel xlsx sheet has some data saved as text that data shuttle is converting to number even when the workflow column type is defined specifically as text. For example '2526 in excel is coming in as 2526 (without the leading ') and causes formulas not to work. The exact same excel sheet can be imported manually (not…
-
keep getting cell limit with data shuttle and no where near limit
Hi, i have 91kish cells, which is not the limit but keep getting an error that it's maxed out with data shuttle. The error: "Your sheet exceeds the cell limit. start using table view to increase sheet capacity or manually move rows to another sheet." This makes no sense, there is no setting other than on the sheet itself…
-
Date with Time uploading in Data Shuttle comes only with Date
Hi Everyone, I'm uploading Input excel having column value "6/1/2022 1:22:23 AM". But after uploading into SmartSheet, it comes only date "2022-06-01". I need exact format which is in my Input file. Anyone help me on this. Thanks, Sandhiya P
-
Mapping yes/no to a checkbox field using data shuttle
I am trying to use Data Shuttle to bring information from an old grant tracking system to a new one, which is in smartsheet. One of the columns in the Excel file (old tracking system) is a yes/no result but in my new sheet I want this map to column that is a checkbox style. So if the answer is "yes" from the Excel file the…
-
Data Shuttle - workflow & row options
Hello, I am trying to set up a workflow to bring in employee data based on certain filters. Once those employees are in the sheet, I need to keep certain fields updated as they change plus remove employees that no longer meet my filter criteria. What workflow actions and row options would I select? (I have all the columns…
-
Using Data Shuttle
I am considering using Data Shuttle, initially to update dropdown lists, and have a couple questions. First, is it fairly easy to get up and running and create flows of this type? Second, in a particular case, there are about 30 sheets that need a dropdown list updated from a column in a master sheet of about 500 rows. Not…
-
Notes, descriptions on my DataShuttles
Smartsheet, I'd like the ability to leave notes, descriptions on my DataShuttles. Much like I'm able to on Dynamic View. This will improve communication between DataShuttle owners and the shared parties without the need for interruptions. Screenshot of Dynamic View Thanks, Eric
-
DataShuttle import if source sheet changes, but name remains the same
I've just started working with DataShuttle to automate a few of our reports. We pull these reports weekly from SAP as an excel file, what we want to do is replace the file each week with the new file. These always download from SAP with the same name (EXPORT.XLSX), and I was wondering if this will effect the upload, or if…
-
How to copy all data from outside Control Center to new sheets?
My original process has almost 200 sheets outside of Control Center. I've recently setup a Control Center workflow and generated the same sheets based on the same template I was using outside of Control Center. How can I automate copying the data from the old sheets into the new sheets? I have access to Data Mesh and Data…
-
Can't make an offload data shuttle to a Sharepoint link
I want to extract my sheet smartsheet on a sharepoint which I have the access, but I can't. I don't know why, i have set up my workflow normally without any changes or filters, but the workflow don't want to success. Please help me!