-
Data shuttle not seeing my file
Hi, I have two files in a location on OneDrive. I have a test file and another real file that I want to upload using data shuttle. When I connect (no prob connecting to OneDrive), however, it is only seeing one file. Note I created the test file in the screenshot, another user created the second file but I have access and…
-
Dynamic View duplication
I am trying to overcome what I think is a MAJOR FLAW in Dynamic View. It couldn't be an intentional limitation because the approach I want to take wouldn't reduce the number of Views I need to create, just make it EASIER for me. I want to be able to duplicate a Dynamic View/ Report PAIR. The report would always be the same…
-
Dynamic View Logic for Required Fields
Hi there! I have a dynamic view created for Event Approvers to go in an Approve or Decline events. Depending on whether they approver or decline an event, I'd like different fields to show in the details panel as required in order to save the approval status update. However, the fields are only showing up as required after…
-
How to stop DataMesh breaking % Complete parent row roll-up calculations?
I am trying to use DataMesh to populate my % Complete column using a helper column that provides % completion based on the Status column (because my PM doesn't want their employees to have to enter percentages, but rather statuses). I have the DataMesh config set to copy what's in the helper cell into % Complete. In the…
-
Data shuttle date filter
Not able to filter dates, ie 1/1/1977 from source Excel sheet. The Excel sheet's date is a formula, would that be a reason it is not filtering dates in Data shuttle?
-
Off loading from Control Center Intake sheet with Data Shuttle
Is there any risk using Data Shuttle to off load data to excel so I can use the data to then in take to a different sheet.
-
Smartsheet Merge for Google Docs authentication error
Hi, I'm having an issue with the Google Add-On Smartsheet Merge for Google Docs authenticating. I have read the following document: Smartsheet Merge add-on for Google Docs | Smartsheet Learning Center. As well as other articles in the Smartsheet Community and Google search and help results. After I click Connect to…
-
Dynamic Dropdown List on Form
I'm working on creating a form for travel document submission. They have to submit travel documents by specific trip number. I want to make the drop down list for trip numbers dependent on the division the select. ie They select Division A, they only get a list of trip numbers for Division A. Additionally I want to limit…
-
Report Dynamics within Control Center Blueprint
Hello, I'm working on my first control center blueprint and am having two issues around reports within the blueprint. As background, I have Data Shuttle deposit all the accounting results across several project IDs in a central sheet within the control center Admin folder. Each project blueprint has an income statement…
-
Global update - cross sheet formula needed
Hi All, While doing a global update I added new column ( type: Contact) I need to change the formula to that column. The issue is the formula is cross sheet =IF({Project Metadata (Do Not Edit) Range 3} <> "", {Project Metadata (Do Not Edit) Range 3}) it is meant to pull a an email address into the column from a different…
