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…
Hello, I am working on a sheet where orders will come in across the country and list local time. I need to be able to convert this time to mountain time regardless of daylight savings time. Anyone have any ideas? Also is possible to convert to the time to military time if it is received in standard time? Below are my…
I have a sheet conditional formatting has been applied so that Ancestor = 0 is one color, Ancestor = 1 is another. Ideally, I'd like to apply conditional formatting so that all rows with Ancestor = 2 are conditionally formatted to the automatic format style except for the last row which will be a different color. I'm still…
I have searched far and wide for a formula that may help me achieve what I need, to no avail. I have a data table that is updated weekly to showcase upcoming launches based on their scheduled launch date. I currently manage this in Excel but the data is currently on a Smartsheet grid. Ideally, I'd like to build out a…
Hello, This one is a bit tricky. I need to create a formula that will look at 4 columns in a row. If text is in any column in that row, based on the column the text is in will need to be text added to the 5th column. The words to enter into the LICENSE CATEGORY FORMULA column will be one of these 4 words: PHARMACY,…
Hello All, I am trying to figure out the best way to create an if statement. In my column RML Status if the status is RML-Current or In-TRL Current I would like my helper column to state ACTIVE. If it doesn't have either of these two status', I would like it to state INACTIVE. How would I go about creating this the…
It looks like you're new here. Sign in to post and engage.