-
Bridge + Third-Party API: Anyone successfully configured IP allow listing for outbound calls?
We're building an integration between Bridge and an external HCM/payroll API. The third-party system requires strict IP-based allow listing for any external connections and cannot accept DNS records or hostnames as a substitute. The challenge: Smartsheet's documentation only references webhooks.smartsheet.com for inbound…
-
Undocumented Bridge schedule limits
I ran into an issue when creating a new workflow in Bridge and got the following error: "You have reached the maximum number of repeated schedules for workflows in your account. You must reduce the number currently used to be able to create new schedules." This took me by surprise since I couldn’t find these limits…
-
How to create a dual dynamic list of unique column values - including a short list of associated values per unique value?
I'm looking to create a 'dual list' of unique column value pairs. I can create a single list of unique column values with a helper Row # column and the following formula: INDEX(DISTINCT(COLLECT({Epic ART Impacts: ART}, {Epic ART Impacts: Epic ID}, [Epic ID]#)), [Row #]@row)) When pointed at a list with MANY duplicates,…
-
How Can I use Smartsheet Bridge to copy a single row to another sheet
I am new to using Smartsheet Bridge and am struggling to find good training / reference material to help me leverage this tool. Hoping to get some guidance on setting up a Bridge workflow to capture previous week's status info and copy the full rows to another history sheet that can be used for trend analysis/reporting.…
-
Where to find SheetID in the Table View
Hi there, How to find Sheet ID in the Table View as it is available in the properties in the Grid view?
-
Multi Year Metric Dashboards
I am looking for some examples and advice on how some of you have set up multiyear metrics. One example of what I am currently working on: I have Behavioral health completing surveys where a lot of the questions are an best to least answer or 1-5 value to choose. They currently track quarterly and by year for metrics. So…
-
Where to start with Bridge?
Hi folks, I am hoping for a pointer in the right direction. I am new to Bridge and need to build a workflow to a) create a project in Resource Management (RM) when the status on a row in Core changes to "Create" and then a follow on workflow that when any of the fields in Core update, reflect those in RM. The challenge I…
-
Bridge - ServiceNow Integration with ServiceNow Access Control List
Hello community! I am developing a ServiceNow - SMAR connector using Bridge. My client has Access Control List (ACL) configured in their ServiceNow environment, which requires an IP address or an IP range to whitelist. Smartsheet only provides a DNS Record for Bridge, and not a static IP address. I have tried using…
-
Row ID for Get Row in Bridge
Let me start by saying how frustrating Bridge and the help guide is! I have been trying to build a simple workflow to copy only 3 cells based on a trigger from source file. I have done exactly everything like stated in Copy partial rows to another sheet using a Bridge workflow. The run logs show as Completed when I change…
-
Bridge - How to Retrieve Data from Multiple Child Runs Given the API Depreciations
Hello Team. Given the upcoming API depreciations, what is the recommended approach in Bridge to use the lastKey to get the full set of results in order to parse them when using the Call API to Smartsheet's API and needing to call it multiple times? For example, if we have greater than 10,000 workspaces and we use the GET…
-
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…
-
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…
-
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…
-
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…
-
Bridge - New Row to SharePoint list
Good morning, I'm working with Bridge and still getting used to the capabilities, and more importantly, the syntax. Perhaps this is not the best option as I am generally pretty good with code, and there is a lot that seems to be hidden or overly simplified. So my "simple" question is how do I set up a Bridge to add data…
-
Sort a sheet using Bridge
Hello, I'm new to Bridge and have been having trouble finding step by step instructions on how to automatically sort a sheet using Bridge. Can anyone help me with this? Appreciate it. Tim
-
Bridge Workflows - Not able to add elements or states to workflow after adding Conditional Junction
Hi Community, I am building a workflow to automatically add 6 child rows to a parent row (which is entered by the user via forms). I am adding a conditional junction to check if the row is added by the bridge workflow or not. However, when I add that condition I am not able to add elements to the success state or fail…
-
Potential reasons why my trigger is not resulting an event during run log (Bridge)
I've completed the authentication process, created a trigger and made sure that the trigger has the right source sheet and event type but I am noticing that I can't get any data from the trigger. My goal is to get the row information when new row is added in my sheet so I can copy some of the data over to another sheet.…