excel worksheet function/formula that will add +1

Question

I've created a spreadsheet for a working group to simply things and not have to do much typing. I have created a row that has a dropdown and when a specific selection is made it will populate a ticket number in the cell to the left. for example the ticket number naming convention is VIA-ECS-2020-001 but if I make the selection for another row it is not creating a sequence, for example VIA-ECS-2020-002 and so on.  How can I get this to auto populate with sequential numbers?

Answer 1

Hope this is what you looking for

The formula in cell B10 

=IF(C10="Ticket Created","TLC-TOC-2020-"&TEXT(COUNTIF($C$10:C10,C10),"000"),"")

and fill it down

If this is not the answer you're looking for please,

take a screenshot of your data and show it to us here so we could understand better your scenario.

Regards

Answer 2

Thank you Jeovany for your response.  It seems that I've been working on this one cell all week only to luck up on getting the number to finally populate when the selection is made throughout multiple rows, but unfortunately I can't get it to sequence the numbers, it just continues to copy the same ticket number with 001.

Answer 3

Thank you so much for your reply.  I need the number to populate only when a specific selection from the dropdown is selected. For example: if I select "Ticket Created" then in the cell beside it will populate with a ticket number, but only if "Ticket created" is selected from the dropdown. If I should choose another selection from the dropdown the cell will remain empty.  This is the formula I have now:

=IF(C10:C7590="Ticket Created","TLC-TOC-2020-001"," ")

I have tried to incorporate +1 but it only copies the +1 at the end (001+1).

Answer 4

Hi Pauletta

Let's say your dropdown list is in cell C2

If your dropdown list has a Dash at the end like "VIA-ECS-2020-" then try

cell B2=$C$2&TEXT(ROW(1:1),"000") and copy (drag) the formula down

If your dropdown list has NO Dash at the end like "VIA-ECS-2020" then try

cell B2=$C$2&"-"&TEXT(ROW(1:1),"000") and copy (drag) the formula down

Note:  Change ranges as per your scenario.

The picture below shows the results

Hope this helps you

Do let me know if you need more help

Answer 5

To:  PaulettaCollins1

re:  sequential numbers

Try...

 ="VIA-ECS-2020-00"&ROW()

Placed in row 2 and filled down.