-
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…
-
Bridge: Improving Workflow to get Group members into a sheet
Hello, Ravali Yelmelwar and I created this Bridge Workflow to transfer Smartsheet Groups and their members from the Smartsheet Admin Group page to a sheet. For our organization, the Workflow takes about 25 minutes to run for 59 groups. Does anyone have suggestions for reducing the run time? Screenshot of the Smartsheet…
-
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 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.…
-
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,…
-
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…
-
Smartsheet Bridge: Duplicate a Workflow
I think it would be extremely helpful to be able to copy/duplicate a workflow that you've created in Smartsheet Bridge in order to slightly modify it for another task without losing your original. Currently, the only way to do this would be to copy the same workflow into a different workspace. The issue with this is that…
-
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…