-
Data Shuttle - How To
I am new to Data Shuttle and am looking for some guidance. Here's what I'd like to do: 1) Extract a subset of activities from my Project Plan - I've created an Offload Data Shuttle to do this. However, I am manually adding fields to this file that are not in the source file but need to be populated in the target…
-
API sheet changes and Activity Log
Hi everyone, Hoping the great minds here can help solve a mystery. We recently implemented Control Center (first started using it on 5-Aug) and one of the manual tasks we've set up a workflow to notify our admins to complete each week is to update the Control Center generated link in our demand management sheet to show…
-
Data Shuttle Export - Inconsistent output for checkbox field
When using Data Shuttle my checkbox fields that are actually checked, do show up as "True" in Excel. However, the unchecked fields sometimes display a "False" value, while most of the unchecked fields appear as "null". Is there a fix for this? Is there a way to either force all unchecked to be either null, or false? One or…
-
DataShuttle Source
Hello, I am working on having SQL load a sheet into a folder on my OneDrive to load data into a sheet on a weekly basis. While using DataShuttle, I get to the Mapping section and it says, 'Please select a Source in order to see dropdown options,' but I've already selected my source from my OneDrive. Any idea what I am…
-
Dynamic View and WorkApps
Hi, I created a WorkApp and am trying to add a Dynamic View as a page via the URL. What I really want to do is share a sheet with contact info for group members so they can search, or filter really, for people and their info, but I’m having a hard time getting it workable in the WorkApp. My understanding was that if I kept…
-
Pivot App not automatically updating
I've created a pivot using Pivot App and the execution frequency is set to immediate, however when I add data to the source sheet it does not update and I have to manually refresh the pivot - does anyone have the same issue or know how to solve?
-
Can I link to an ODBC data source and have the results popluate a smartsheet grid?
-
Prevent previously transferred rows from being re-transferred when run Offload in Data Shuttle
Hi, I have a Smartsheet being used for primary information intake for assets via a form. Each new asset is given a unique ID and when certain columns in this intake sheet are populated and reviewed, user can hit a checkbox marking the row for offload via Data Shuttle. The data moves to an Excel sheet attached to the…
-
Team can no longer add projects to their timesheets in Resource Management
Hi all, Previously, my whole team could add an extra project onto their timesheets in Resource Management by clicking the plus button that reads "Report Time for Something Else" and searching by project name or number. All projects were searchable. Well, now, that options still shows, and they can still click, but now when…
-
SCC and Data Shuttle
Hi SS community, I want to include dropdown list updates in my SCC blueprints. Is it possible to build in a data shuttle workflow into a control center blueprint? Or do you have to "create a project" and then run a data shuttle workflow after.
