Continue Count When Row Is Moved To New Sheet
I'm attempting to create an auto-number row that takes into account what year it is for a ticket submission form sheet. To do this I realize I must use a formula instead of the autonumber column. However, I want the auto number to continue once a row is moved to a new sheet (The row gets moved and deleted from the original sheet once the ticket has been marked complete). My current formula to output "2023TIC-X" is:
=YEAR([Date Ticket Was Created]@row) + "TIC-" + COUNTIFS([Date Ticket Was Created]:[Date Ticket Was Created], AND(@cell <= [Date Ticket Was Created]@row, IFERROR(YEAR(@cell), 0) = YEAR([Date Ticket Was Created]@row)))
However no where in this do I take into account the ticket numbers on the completed tickets sheet.
Help Article Resources
Check out the Formula Handbook template!