-
Data Shuttle dropdown menu not updating correctly according to filters
I have a drop down menu in a sheet and corresponding form that I want to automatically update using data shuttle according to todays date. I want the drop down to have selections for certain months, and then as time passes and cut-off dates are reached, those months are removed and are no longer available from the drop…
-
Any success creating a new Jira ticket from Smartsheet using the Jira Connector?
This is supposed to be doable. I created a Smartsheet sheet that has all of the required Jira fields as columns. From the sheet I created a Smartsheet Form to collect all of these Jira fields. I then connected to our Jira instance with the Smartsheet Jira Connector and made sure the field mappings were bidirectional. No…
-
Roll out new automations through control center
Hi there, I'm wondering whether I can implement additional workflows by adding them to the source sheet for a template? For example, I need to add an automation to all risk registers. If I add this to the template sheet for the risk register in the control center blueprint, can I then force this update to all risk…
-
Data Shuttle with MS Teams
We are downloading data from our operating software, and saving it in MS Teams, with Data Shuttle pulling information into Smartsheet. It works fine, as long as the file in MS Teams is open, which is not ideal. Any suggestions on why the file in MS Teams has to be open and how do I get around that?
-
Update Dropdowns - Data Shuttle
Hi all, I have an intake sheet with all of my projects in the pipeline and I have time sheets for around 50 users. Each user can have as many projects assigned to them that they are tracking time towards (this all resides in their respective time sheets). I want the list of projects from the intake sheet to show as…
-
"Sheet Access" report that includes shares to Dynamic Views
Hello - In order to maintain our implementation of Smartsheet so that it is HIPAA-compliant, we need to perform periodic user access reviews that involve content owners reviewing users that they've shared content with and taking appropriate action. The "Sheet Access" report that Smartsheet offers is very helpful for this,…
-
Columns I just made does not show in my coworker's workapps
I just created 4 columns so one of my coworker can fill them with the corresponding information, but they are not showing in her workapps, as she is a owner to a project, what should I do? Should I share with her the worksheet again ?
-
WorkApp Sheet Filtering
Hello, I recently set up some work apps for my team and I noticed that the filter button is greyed out, it's an essential function in their day-to-day workflow and I can't seem to find a work around, any help is appreciated.
-
Control Center Summary Roll Up
I am trying to create a roll up sheet that adds up my project information from each of my existing projects as well as when I create a new project. Right now I have waste tracking sheets in each project folder that are capturing data and a metadata sheet that sums up that data to show the totals for each year. What I am…
-
Changing logo on a workspace via control center
Hello, we use control center to create workspace that contain templates. The workspace are used for different clients. Each client has a logo that we collect in the intake sheet (this is the sheet that is used by control center to create workspaces) we know the manual way of changing the logo, but we also know that there's…