-
Using Data Shuttle to check for duplicate values
I am trying to have data shuttle check if something on the target sheet already exists on the file I am using in Data Shuttle. For example, my target sheet has UPC, UOM, Vendor Name and Vendor Part number. I want to have it check the file I load into Data shuttle and return the Internal Part number if it matches those 4…
-
Data Shuttle flows not running
I tried making a few data shuttle upload workflows. The intent was to have any updated data on an excel file in onedrive, sync back and update in smartsheet. I properly mapped my columns and have a unique id that matches in both datasets. I set these to a manual run instead of a schedule. When I hit 'run' it spins for a…
-
How do you avoid Power BI Semantic Model Error when column headers are modified (add/remove/edit)
For anyone connecting Smartsheet with Power BI and using sheets as sematic model, and set a scheduled refresh, you might have encountered errors where when a column has been modified, whether add or removed or renamed, the refresh is halted until. My usual fix is to download the PBIX and update source (Navigation) to…
-
Issue With Teams Integration not opening Dashboard Links
We just configured our Smartsheet MS Teams integration, and have been adding a tab linked to our project dashboard, which contains links to various sheets within our projects. Links to forms work, however the links to other sheets within the project all give the error "The sheet you were trying to open has been deleted."…
-
Bridge: "Required object attribute(s) are missing from your request: row.id." (JSON Formatting)
I'm not kidding when I say I've spent 8+ hours on this. I'm no programmer so ChatGPT has been pretending to fix it for me, unsuccessfully. I have the problem narrowed down to the JSON output. ChatGPT keeps asking me to update my code and the HTTP Request body in various ways without much change. You'd think this would be…
-
Bridge Newbie - Trying to Update Dropdowns
Hi there! I'm trying to update a dropdown menu using Bridge for the first time. The workflow thinks it is running successfully, but the dropdown values are not being updated on the target sheet, so I've done something wrong. Upon running, it is still blank of any dropdown values despite my source column having three…
-
Adding my own code to create get to know you page
I want my team to be able to share their interests and expertise on community board. I wrote the code in Java and Python. Can Smartsheets post the code for me in my teams community?
-
Dynamic drop down Data Shuttle not working
Tried both options of Data Shuttle workflows (upload and offload), but neither is working. I've followed the help article available, but it's not working. Getting stuck at the "map column" section, where it always says that column is not mapped. Any help is much appreciated.
-
Calendar App in Dashboard - remove list of calendars
I am embedding a calendar app into a dashboard using the web content widget. Even though I am using the direct link to the calendar, sometimes the full list of calendars I am shared to appears in the dashboard vs. only the calendar that should be displaying. Is there a way to embed the calendar so this doesn't happen? I…
-
Bridge: Variables Passing Through to Child as Text, Not a Value. "{{variable}}" instead of 123124932
WORKFLOW PURPOSE: first it gathers and populates our entire users list to a sheet. This child workflow is supposed to use /users/{{userId}} to populate the DETAILS of each user onto the matching row that was just populated. But… I can't get Smartsheet Bridge to pass-through the variables I've set to the Child Workflow.…
