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