-
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…
-
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.…