-
Data Shuttle: Target sheet is empty but all rows are "unaffected" after running workflow
Hello, I am new to Data Shuttle and creating my first Upload Data workflow. My target sheet does not have any data in it: everything is blank (it is a new sheet). When I run the workflow however, the run details say that there are 77 rows unaffected (as in there are 77 rows where data already exists and is consistent with…
-
How can I use index match + either another index match or an IF statement to pull Data from multiple
How can I use index match + either another index match or an IF statement to pull Data from multiple sheets? In my case I have 3 sheets: Sheet 1 - Current Project List - consists information that track active projects. (each Project has a unique project code) Sheet 2- Closed Project List - consists of previous years…
-
Rank Pivot Results WITHOUT DUPLICATES
Hey friends, I am trying to create a column that ranks (without duplicates) the results of a PIVOT configuration. The PIVOT config produces the SUM of rental dollars spent, in column "Grand Total-SUM 💲 Total Rental $ Amount {H}" respective to each listed equipment type, in column "⚠️Cat-Class Description". I'd like to rank…
-
Combine emails into a multiple-contact column / multi-contact column
Multiple-contact columns can be problematic to use in Smartsheet. Namely, they cannot be "put together" with a formula. There's many use cases where you need to build multiple contacts into a cell based on criteria/lookups, but there isn't a way to do that in native core Smartsheet. There is, however, a couple of methods…
-
ERROR Data Shuttle : Workflow Execute: [object Object]
Hello everyone, I have been encountering an error for some time on Data Shuttle. This is: "Workflow Execute: [object Object]". But I don't know what it means. Do you think you can help me? Azerty64
-
"Please select a Target before configuring the Mapping" error in Data Shuttle
In Data Shuttle, I'm running into a "Please select a Target before configuring the Mapping" error on the Mapping page, but I've already selected a Target sheet. Mapping: Target: I ran into the error when creating a new workflow, so I went to an existing workflow to see if I'd run into any similar issues. I Next-ed through…
-
Data Shuttle when they are more than one line for the Unique ID
I have a source file with a mess of data. I pretty much have it cleaned up so that for each of my phase dates I have a raw data file that I can export and attach into my clean sheet. The problem is that once it hits the first row with the matching opportunity ID# (unique field) it stops matching. I need it to go to the…
-
Just Released - Data Shuttle Search Bar
Hi Community, If you have as many Data Shuttle workflows as I do, whenever you’ve gone to edit a workflow you have probably felt the pain of scanning through a very long list to find the specific workflow in question. Well now we have a search bar in the “All Workflows”, “Upload Workflows”, and “Offload Workflows” pages of…
-
Are You Able to Join Two Columns into a Data Shuttle Dynamic Dropdown?
Hi everyone, I'm hoping someone here can help me out with a challenge I'm facing in Smartsheet's Data Shuttle. I've been trying to use expressions to combine two columns into a single dynamic dropdown column in a target sheet, without changing the source sheet. For example, I want to combine Num and Name into a format like…
-
Data Shuttle Automation Question
Hi, we are exploring data shuttle for a welcome kit program. Smartsheet has told me we can connect with ADP workforce now but I can't understand how automated it is. HR wants to not have to do ANYTHING. i.e. they enter a new employee's information into ADP workforce now and it automatically flows the critical info (name,…