-
Have two auto-number or rank by created date?
Okay, so I have been working this problem for a few days and it's officially making me crazy. Here's the problem statement: I have 3 intake sheets for different business units. Each has an Auto-Number column that has a prefix for the BU. I need to consolidate all of the attachments from those 3 sheets into 1 sheet. So on…
-
Auto Numbering
Hello I would like to add auto numbering to my sheet but I would only like it to start from row 34. How can i amend this as it starts from row 1
-
Autonumber when
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…
-
Does changing the prefix of an auto numbering column stop a row from transferring to another sheet?
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…
-
auto number is greyed out
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.
-
IF Formula and Auto Numbering
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…
-
Date Added when my Primary Auto Populates?
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…
-
Auto Number column for only NEW rows
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…
-
Auto Numbering (1, 1.1, 1.1.1, etc)
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?
-
Auto filling quote number column using automations?
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…