-
Why is my workflow not updating my Smartsheet columns after initial run?
I have set up a workflow from an excel file to my smartsheet. I have it set that whenever a new sheet is added it should update my data, but that is not happening. Ex. One of the columns is for prices. If the new source attachment has new prices and i add to the workflow, the price does not change in the Target sheet when…
-
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…
-
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,…