-
Bridge: How to automatically add users to "Licensed Users Group" or "Other Users Group"?
We're trying to maintain a "group" of users in our Smartsheet instance who are Licensed, so that we can use Smartsheet to share Licensed-user dashboards with them. And if they're not licensed, they would go into "Other Users Group" for a dashboard highlighting features available to free users. Currently, we intermittently…
-
Bridge | How to Find Rows With Status & Delete Them
I'm trying to use Smartsheet Bridge to find all rows within a Jira Status column that are closed and have it delete those tasks (rows). I've been looking at multiple articles but am having a hard time referencing what rows match this cell and then delete.
-
Bridge Question: How do I Add a "^" as the First Character in All Cells in Sheet
I'm trying to use Bridge to add a ^ in front of all text in every cell in a sheet. If it works, it'll allow me to turn sheet formulas into text that can then be treated as text, which Smartsheet can actually back-up. I would likely schedule the bridge flow to run shortly before the scheduled Sheet backup. Then I would…
-
How to process pages in Bridge
Hello friends - how do you "loop" your workflows to process multiple pages of data in Bridge? For example, if I GET a Sheet, 500 rows at a time, and have 5 pages to process, how do I get page 2 when I'm done processing page 1? I tried using Alt-click to loop back to the top of the workflow but that doesn't work. Once…
-
Bridge - Google Translate - How to translate Smartsheet Form?
Hi, I just got Smartsheet Bridge and I am still trying to learn how to use it but the resources are very limited. I have global users who use Smartsheet Form to submit survey. We face a challenge with a language barrier and I would like to utilize Bridge and Google Translate and give them the option to translate survey…
-
Reference Values in ServiceNow table unable to process into Smartsheet
Hi. I have set up a connection between ServiceNow table and Smartsheet for when records get updated, it will feed back into Smartsheet. However, for the "Teams" field in my ServiceNow record, it references another table and can sometimes contain 2 or more Team names which shows up as Sys_IDs when I look at the Run Log.…
-
Bridge examples including Javascript
Hi fellow Smartsheeters! In preparation for my session at Engage 2024, The future of workflows, I'm posting a variety of live Bridge examples to this thread. Each "block" will have a use case description, workflow layout, and (if needed) the javascript code I used. Enjoy!
-
Bridge workflow - delete a row when a trigger is met
Looking for guidance and best practice! High level - We have an intake sheet that includes two columns that have multiple selection dropdowns. In order to separate those data points for reporting, I created regional and channel sheets, along with automations that separate the data fields. All work is done on the intake…
-
Bridge - Copy Specific Cells to Another Sheet
I'm trying to use Bridge to copy only 2 cells over to another Smartsheet. I've been trying to create the workflow in Bridge using the how to guides that Smartsheet has on their site but unfortunately I can't seem to get it to work. Sheet 1 - Has a form that people can enter in when they aren't using their desk in the…
-
Error Code Bridge
Hello, When setting up the trigger for a new bridge workflow I am receiving this error when i try to save the trigger. I am admin on the source sheet Event Type: When column values are changed I checked the column name and the sheet ID and everything is correct. Can someone clarify what the issue is? Do I have to be owner…