-
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.
-
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…
-
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 + 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,…
-
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…
-
Smartsheet API List Workspace Children
Hello, I'm trying to use the Smartsheet API to get a list of sheets in a workspace using: https://api.smartsheet.com/2.0/workspaces/{workspaceId}/ However, my workspaces are organized with folders and this only returns the top level folder and nothing else. How can I have this return every child object in the workspace no…
-
Using Bridge to update dropdowns
Hello, I am trying to update a dropdown in a sheet using values from a report using bridge, but am running into a problem where the array in Bridge is capped 10,000 rows. My dataset from the report is currently around 80,000. Below is my current setup. Is there different way that I could go about setting this up to capture…