-
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!
-
Smartsheet Bridge: New Junction
Hi, I am exploring the "New Junction" in Bridge. When I add a value in Context using the dropdown, e.g. sys-animals, Bridge complains of unsupported module. Can someone please shed some insight into how the Context and Values To Check For can be used? Regards, AK
-
How can I hard code a cell based on a trigger?
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…
-
BRIDGE + AI: Share How you Taught your LLM to Help you Create Bridge Workflows Successfully?
I may be speaking to a very small group of users here, but this message is for those who successfully have their AI LLM teach them how to create solutions using Smartsheet Bridge. I'm attempting to train ChatGPT to understand how Smartsheet Bridge works so that it can help me create solutions that WORK. Unfortunately,…
-
Using Bridge and Conditional Junction to evaluate if a Checkbox is Checked
I'm trying to set up a conditional junction in Bridge to evaluate whether a checkbox is checked. The checkbox is not manually selected; it's calculated using a formula in the Smartsheet row (e.g., =IF(COUNT(CHILDREN()) > 0, 1, 0). When I use Get Row in the workflow, the checkbox field displays true when checked and false…
-
Row ID for row created in the previous module is coming back as not existing.
I'm running into an issue in Bridge where a row I just created via the Add Row module, is coming back as not found when I try to use a Get Row module, referencing the row it just created. Goal: I have a workflow where I am adding a row to Sheet B, by copying data from sheet A. When that new row is created, an Auto Number…
-
Rename Bridge Workflows and Workspaces
Bridge is a lot of trial and error, and because of that we don't always know what a workflow should be named when we start. It would be incredibly helpful if we were able to change the name of workflows and workspaces at any time in the development.
-
I Can't Get Bridge's match function to match anything
I feel like what I'm trying to do is simple but nothing is working. I'm following this help article: Copy partial rows to another sheet using a Bridge workflow | Smartsheet Learning Center What I want to do: When the column titled "Trigger Workflow" is changed to "Yes" It runs. It checks to make sure that the value is…
-
Bridge Workflow Export
I have just recently found use cases where I needed Bridge. I created a sheet with unpivotted data. I have a love/hate relationship with the tool for now. I really like flexibility and power, what I don't like is how difficult it is to troubleshoot and in some ways manage the workflows. Seems to be some sensitive points…
-
Bridge: Way to delete all rows in a sheet
I've found a few ways to delete all rows in a sheet using scripts and multiple workflows, but I was wondering if there's an easier way to merge this into one flow. I just have the flow check if a row exists in get sheet, if there is a row then delete row 0, until the array = 0 then it stops. It works, but it's just super…