-
Smartsheet to Google Sheets Sync for Dynamic Dropdown
I have a Google Sheet where the data will be updated by the project managers and this data will be uploaded to Smartsheet using Data Shuttle. Now I have another smartsheet which is a Database of resource Team.I have a Resource Name column in Database(smartsheet) that will be updated on every new resource is hired. That is,…
-
Pivot App Values (Dates)
How do I create a pivot table, using the Pivot App to display dates (06/03/26) as values? Currently, ony SUM/COUNT/AVERAGE appear as drop down options.
-
Control Centre: Return Form URL in Metadata sheet
Hi All! As part of our Control Centre build, I would like add the a link to our Invoice form in our Summary Sheet/Top level reporting. This would allow users to quickly navigate to the scheme level forms. Is it possible to automatically return the URL for a form in Control Centre, and map this to a metadata sheet? Thank…
-
Owned Calendars Not Appearing after changing Primary Email Address
Has anyone else had the experience of all the built and owned calendars disappearing from the calendar view if you change your primary email address? I have added a new alternate email address and folks in my company can assign me work using either the primary or alternate. If I change the primary to the alternate, then I…
-
Calendar App Embedded in Dashboard — Requires Refresh on First Load Daily
We've created portfolio-level calendars using the Calendar App and embedded them into our dashboards via web content widgets. However, every time someone accesses a dashboard for the first time each day, the embedded calendar doesn't load the correct view — instead, it displays the Calendar App home screen (the "select a…
-
Get project hyperlink from metadata into other sheets
This discussion was created from comments split from: Hyperlink to Project Dashboard via Control Center.
-
Complex dynamic dropdown set up
Hi Community Have a situation that appears quite common across this group and wanted to get some feedback/ideas/guidance before I begin building. An internal client has set the challenge of building a basic 'visit log' tracker. I see two complexities; one is that there are three levels of information to reach the final…
-
PowerBI Connector and Reports - Visuals Stop Working after Gateway-side Refresh of Data
Context: I worked on a dashboard that's pulling dozens of sheets and merging them together into a dataset. It's time-consuming to add each Sheet to PowerBI and requires many manual steps. I've explored using a Report as it can automatically pickup new sheets automatically, adds the sheet name, etc. When I import into…
-
Link to Form on a Dashboard via Control Center
We have a custom toolkit in Control Center with many sheets including an action items log, which has a form for new items. We have never included a link or other widget on our project dashboard design, but we're looking at that option now. I tried using the Shortcut widget, but when a new project is created, the link…
-
Creating Tasks and Subtasks in Smartsheet to Jira
I am currently working on a project where we would like to set up a template of tickets to log into Jira and am using the Jira connector to push from Smartsheet to Jira. We have figured out how to do the intial ticket but when we try to use the type of subtask, we get the following error: Invalid response from JIRA.…
