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'm importing an Excel spreadsheet of an Issues Log to start my sheet that has ID numbers that I need to retain. I want to start a new column and only have Autonumber applied to any new Issues that come through and not change the legacy Issues IDs. Any thoughts? The imported spreadsheet has 461 items so I want to start the…
I have two sheets; one is an originating sheet that has an auto number column. For this sheet, I designated the prefix of 'WO26' for the numbering convention. The 2nd sheet is a 'dumping' sheet that started off blank; due to the addition of the rows transferred from the originating sheet, corresponding columns have been…
Trying to use auto number in form. It let me set it up the first time but it didnt work so I tried to edit it but it wouldnt allow me to go back to that screen. I deleted to form and tried again but the suto number option is still greyed out.
I'm looking to use the below formula however I get an 'INCORRECT ARGUMEMT' error message: =IF(Type@row, "Form", "F-" + [Auto #]@row, IF(Type@row, "Report", "R-" + [Auto #]@row)) Additionally, I'm looking to add this funtionality to a sheet that already has some R-XX and F-XX entries, and looking to automated the numbering…
Hello! I am trying to find a way to use an automation or something of the sort for when a specific cell is no longer blank. Context: Primary Column is linked to a hidden auto-numbering column The "Date Added" Column was working for a while but every now and then the sheet will add about 5+ empty but numbered rows at the…
Hi - We have a sheet where we are tracking issues, and we'd like it to assign the next number in sequence once a new row is submitted via a form. Below, the "Issue Number" column is the primary column, so I cannot make this an auto-number column. What would be the simplest way to implement this? I cannot include other…
I am trying to get the Auto Numbering feature to allow row ID numbers that correspond to the level of the task. e.g. Highest Level task = 1, Next row (indented) = 1.1, etc. Is this possible in SS?
I want my quote number to auto populate a quote number only when a new job row (parent row) is added. We use the quote number NV25-0xxx (ex: NV25-0258, NV25-0259). Multiple clients requesting the same job go in children rows, the children rows get the same number as the parent row so I do not need new quote numbers(I added…
There seems to be something odd happening in some of my sheets and I don't understand why it is happening. Can you explain? See screenshot. It is not because I am using the copy down functionality. Also, If I do have a project name that ends in a number and I need to identify this for all rows. What is the best practice?…
It looks like you're new here. Sign in to post and engage.