Smartsheet Support Documentation does not have a way to duplicate, copy, or export a group in admin.smartsheet.com/manage/groups There is, however, a workaround that doesn't appear to be posted anywhere so I'm sharing it here: Open the group in the group list at admin.smartsheet.com/manage/groups Select "View Group" Select…
This is the simplest formula I can find to add Months to Date. This considers sum of months exceeding 12, converting it to January and adding 1 to the year. Where: Term column is the number of months to add, Date is the starting date. =DATE( YEAR([Date]@row) + INT((MONTH([Date]@row) + [Term]@row - 1) / 12),…
Using URL queries to pre—fill forms seems to be catching on a bit more lately. There are a lot of resources out there, but they can be kind of spread out, so I figured I would start a thread that has some of the lessons learned, tips, and tricks that I have discovered along the way. Tip #1 [info callout] The first one that…
Hello! I've encountered an issue while integrating NetSuite and Smartsheet via API. The script works inconsistently and occasionally creates duplicate rows in the Smartsheet table. Current Script Logic: A record is created in NetSuite, triggering the script. The script collects data about the parent row. A request is sent…
Hi everyone, I'm building a Smartsheet Bridge workflow to get the activated rows from my contact sheet and update another sheet. I'm using the Get Sheet module to retrieve all row details, but it pulls in every row — including the ones I don't need. To solve this, I tried using the JavaScript module to filter the rows, but…
I am using the API function to return a list of users as an array; Then I am using the Javascript Module to filter those users whos status is "DEACTIVATED" But I get the following error: "workflow execution failed: Plugin Error ERR_PROCESSING : failed to execute extension module : require is not defined" Here is my…
Here is the full solution for how to iterate over an array using JavaScript. Smartsheet provides a partial and incorrect solution at https://help.smartsheet.com/articles/2482603-javascript-module-reference. Below is the actual solution. Using Bridge and JavaScript, this example extracts the list of column names from a…
It looks like you're new here. Sign in to post and engage.