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…
I've not seen any requests for a Smartsheet's equivalent to Excel's OFFSET() function. For how universal the INDEX(MATCH()) solution seems to be, it strikes me as a notable oversight that there isn't any function to achieve a similar effect for selecting a range of cells offset by a column index value. It would greatly…
Hi there, I've got a sheet [Sheet A] that needs to summarize another sheet [Sheet B], where each row on Sheet A needs to reflect a column on Sheet B. I can do this very easily with a SUMIFS function. e.g. Sheet A Row1 =SUMIFS({Sheet B column 3}, {Sheet B column 1}, "example", {Sheet B column 2}, true). The issue with this…
I am trying to use Bridge to pull all the contacts (Supervisors) from a roster grid that match the department defined by my trigger and then put all of these contacts into one single cell on my project tracking grid. So far, I've been able to get the array and then extract the emails I would need but there's a couple…
This solution copies all attachment names from a source row and adds one row for each attachment name onto a target sheet. Each target row contains one attachment name and the source row primary key. The solution uses a Child Workflow to get individual data values from an array in the Parent Workflow. The solution is very…
I'm creating a workflow to populate a drop-down column with a large number of values. It looks like there is a 100-node limit to the row array being returned. Is this true, and if so, how do you increase this limit?
=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.