-
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.
-
Data Shuttle Changing Column Types
Hello, I set up a new upload workflow to bring in data from a google sheet, and when the workflow ran it changed a handful of column types in the target sheet from text/number into drop down columns. This change broke all my formulas in a metrics sheet... After changing the column types back to text/number, all my formulas…
-
Notifications not being received by @gmx.com email addresses
I have a set of workflows that send questions and replies to users on regular intervals. It seems as though users with @gmx.com email addresses don't receive any notifications, but those with @gmx.co.uk do. Any suggestions on how to resolve the issue?
-
Using Data Shuttle to Load Start Date and End Date for Legacy Resource Management
Good day, I am trying to load a high-level milestone plan from an external data source that has the start date and end date already established using Data Shuttle. I have enable Legacy Resource Management on the target sheet and get an error that the End Date and/or Duration can not be updated. Is there a workaround to…