How to use Data Shuttle Expressions
Hello everybody, I hope you are well. Could you please help me understand how to use Expressions in Data Shuttle? I have watched the webinars, and help pages and I can't figure it out. I don't have a use case specifically but let us say I would like to add an expression that looks at a date in the origin file and then…
Linking an Excel cell to Smartsheet a cell
Dears, I would like to collect status updates from test scripts created and used in Excel and present it in Smartsheet. All test scripts in Excel have one cell indicating the percentage completion level of the test script. Objective is to link that one cell to Smartsheet sheet where I present the list of all test scripts…
Dynamic View Owner Vs Admin
Does the Dynamic View Owner (Person 1) have to be an Owner or Admin of the underlying sheets to be able to share them in a Dynamic View? Person 1 set up 50 sheets successfully in a Smartsheet Report using the Current User function to bring together all project plans across the workspaces. This Smartsheet Report was used to…
Error: Trigger Alert Someone workflow on a daily or weekly basis.
Can someone explain to me why this automation works: But this automation throws an error: The error occurs when I try to change the trigger to "daily" or "weekly". The error is as follows: According to this smartsheet article, there should be no problem with this workflow: Trigger frequent, change-based automations in…
Update Requests via Dynamic View
I think I know the answer, but am I able to set up an Update Request workflow automation that comes from Dynamic View? I need some individuals to be able to update certain fields, but we do not want to give them editor access to the main Smartsheet. So we created a Dynamic view for them to make updates, but I need to…
Can't see field in detail panel - Dynamic View
Hi- I added several fields in the Dynamic view detail panel including 2 multiple-line text fields at the end. I saved the view but cannot see them in the detail panel. any suggestions, please?
CC - Applying a group to a workspace via Control Center
Hello I have an intake sheet where the Project Owner is given ADMIN permission level in the 'Customize Profile Data' screen in CC. The intake column is a contact list dropdown. I have added an additional column to the intake called ' CE Team'. I want to also give these Users ADMIN access as above. When I replicate the…
Data Shuttle Failed: Server Timeout
I have had daily data shuttles fail lately, this merge workflow has been running for months without issue. Anyone else seeing this?
Distance Between Addresses or Zip Codes
Hello, We have an expense reimbursement form that we're using for a group of employees. One of the reimbursement categories is based on the distance from their home to the festival site. I don't think it's possible as it stands, but I wonder if anyone has used a 3rd party application to calculate distances between…
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…