-
Change Date column if new row is added after hours
Hello - We have a simple ticket system and if a ticket request from a form comes in after 4:00pm, we don't start the ticket until the next day. Case: Form Entry happens at 2:30pm on 07/27/23. Start Date column should read 07/27/23. Form Entry happens at 4:30pm on 07/27/23. Start Date column should read 07/28/23. So we want…
-
Bridge: How do I dynamically pass RowID or Object to child workflow?
Hello, Does anyone know how to use Bridge to dynamically collect the RowID from a parent workflow to use in a child workflow? What I'm attempting to do is have a workflow run daily to look at a sheet and collect any rows with a checkmark for "due today". Then I want the workflow to only take specific data and build a JSON…
-
Bridge: Add Row module with empty cells
Hello - I am working a Bridge workflow to Get Row from a source sheet, and Copy Row with select columns to a target sheet. The workflow between the sheets is working great, but my question is that some row cell information will be blank from the source sheet going to the target sheet and thus my Get Row Cells Values come…
-
Extract List of Unique Values
Hi Is it possible to use Bridge to extract from a column a list of values, run a JS to extract an array of unique values, and then pass this to another sheet and update another column with this unique list?
-
Bridge Salesforce API - SF Contact Module
We're looking to pass contact information associated with Salesforce opportunity records into Smartsheet. We have the Smartsheet / Salesforce Connector in place, but following the current structure would explode the number of fields necessary to denote all possible roles associated with each project. Is it possible to…
-
Auto Attach Report .pdf to new source sheet row
Is it possible to take data from a Report and have it auto export as pdf/excel file and attach that new file to another sheets row? Case: We have a User Access process built and once a month, the primary owners of each software need to review the user access as a pdf file. We were using the "Send as Attachment" feature in…
-
Bridge Workflow - Runs with no Errors but doesn't copy data to column. Am I missing modules?
I have a Bridge Workflow that is set up to copy data from a row/column to the same row/different column. The workflow runs with all module steps "SUCCEDED". However, the end result is not copied in my Smartsheet's target column. Its blank. Am I missing a module or module steps to complete the copy routine? -- Here's a…
-
Bridge Smartsheet Salesforce integration - redirect uri mismatch
Hello, I am trying to setup the Bridge Smartsheet Salesforce integration. I have followed the Smartsheet provided instructions at https://help.smartsheet.com/articles/2482029-salesforce-integration-overview-bridge to setup the Salesforce Connected App. I get the redirect uri mismatch error which says the redirect uri must…
-
If you have Bridge, what are you using it for?
We just got Bridge, as I try and learn it, I am trying to think of all the use cases. Also, has anyone done anything with Bridge and Data Tables together?
-
Adding Users to a Group
I'm trying to build a workflow that will automatically add users to a Smartsheet Group if their email is our company's domain (to make it easier to share WorkApps and some universal workspaces). I've got everything working but the darn HTTP call to add to the group I am using Get Row to pull email addresses from my Users…
