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…
Hi Guys, Created a basic script to download all PDFs from a sheet. Use case: I use Document Builder to create documents from field inspections. However, we need to store these in sharepoint for redundancy. This script basically pulls all "PDFs" so you can then migrate them where you need to. I don't want to pay an…
I was trying to use the Scheduling: Create Workflow Schedule module in Bridge to set up a 60-minute timer that would alert our team if another workflow didn’t complete within that window. I was struggling with how to pass and access state values between the workflows. After working with a Pro Desk support agent, we figured…
Hi everyone, I just started working with the SmartSheet API. So far, everything has been straightforward, except one thing; I am trying to submit new rows to a sheet but can't seem to get the value of the Multi Picklist right. If submitted as a string in various formats, the value only displays as one long tag including…
Hello, I have a column with different bar codes scanned. Only FedEx has some 30 digits, so i need the formula that will look for 30 digits in a cell and copy past last 12 digits to the adjacent column. I know how to use the "RIGHT" formula, but dont know how to tell it only for the cells containig 30 digits. thasnk a lot!
Hello Community I created a form with multiple drop down options. I need to parse out those options so each one shows in a separate cell. I figured out the first one but cannot find the correct formula for the second, third cells, etc. Any help is appreciated. Below is the formula i used to parse out the first item (thanks…
=JOINARRAY([End Delimiter],Range 1, [Range 1 Delimiter],...) *No delimiter for last range listed. =JOINARRAY(", ", A:A, " ", B:B) results in: x 1, y 2, z 3 blank values are ignored, hence the over-ride for the end of the item delimiter
It looks like you're new here. Sign in to post and engage.