-
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 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…
-
Plugin Error INVALID_DATA : failed to execute extension module : {"statusCode":400,"message":""}
I have a clear sheet workflow (thanks to @Brian_Richardson and his wonderful article!) that was working great. Then, with no changes, i received the following error code. The run logs are also saying unavailable. I duplicated the workflow to make sure nothing was corrupt, same error message. Any help would be appreciated!
-
Get Sheet Module with Filter Rows - Smartsheet Bridge
Hi everyone, I'm building a Smartsheet Bridge workflow to get the activated rows from my contact sheet and update another sheet. I'm using the Get Sheet module to retrieve all row details, but it pulls in every row — including the ones I don't need. To solve this, I tried using the JavaScript module to filter the rows, but…
-
Bridge - Auto Delete Newly Added Columns
Hello, I've been trying to create a workflow in bridge that when a Move Row automation happens to a target sheet. There are certain columns that will be delete each time the Move Row automation happens. So in this example, the row is moved to this sheet, because the last two columns aren't in the sheet, I want to delete…