-
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…
-
Pivot does not update
the pivot table does not update if I change some data on the main table. Does anyone know how this can be solved? thank you,
-
How to get updated dates in CC Summary Sheet
Hi, I am trying to set update the summary sheet for our Control Center blueprint to show dates from the project plan rather than the original dates entered in the intake sheet. The new dates are captured in the summary data on our schedule sheets, and are selected as profile data (as date types), but they don't appear in…
-
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…
-
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?
-
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…
-
Is it possible to automate the process of uploading a document to data Shuttle?
Has anyone here used Microsoft flow or other tools to automate the process of uploading a new excel file into Data Shuttle? Wanted to see if its possible or if it has to be a manual process
-
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…