-
Bridge Search for a value - What are the modules to use?
I have a use case as follows: When a row changes or is added in the source sheet, I want to search for the row's column named "Key" against a column also named "Key" on a target sheet. If found I want to update a column named "History" in the target sheet that matches the source sheet's key. I also want to write the word…
-
Bridge: Update Columns--With Colors?
I'm curious if there is any way to associate colors to the values using the Bridge "Update Column" element. The first column in this image is created manually. The second was created using Bridge. It's not in the API documentation ..and is clearly not in the element: Any ideas?
-
Bridge: Automatically backup a workspace using "Save as New"
Would anyone be wiling to share their Bridge Workflow and Script that automatically backs up a Workspace by using "Save as New"? I hope there are many of you with a solution like this since Smartsheet's backup option is very limited, whereas "Save as New" preserves EVERYTHING. Please and thank you!
-
Update multiple column dropdowns on one sheet, from one source sheet using Bridge
Hello! Bridge newbie here. I have successfully set up a Bridge to update the column dropdown for one column from one source sheet. I'd like to build off this bridge to update multiple columns dropdowns on the same sheet, using the one source sheet. Is this possible? Here is what we have set up so far. @Genevieve P.…
-
Adding Users to a Group
I'm trying to build a workflow that will automatically add users to a Smartsheet Group if their email is our company's domain (to make it easier to share WorkApps and some universal workspaces). I've got everything working but the darn HTTP call to add to the group I am using Get Row to pull email addresses from my Users…
-
Bridge & ServiceNow Integration
Hi Smartsheet Family, I am trying to integrate ServiceNow with Smartsheet at my job and I am having some trouble. I know some of you have successfully done this so help would be much appreciated. I was able to get an OAuth where the client ID and secret was auto generated but our SNow team created a SNAPI account for me to…
-
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…