Auto-Increment Change Orders

Charles Stiles

I have a column [Entry Type] which contains (Task, Change, Other). I use a web form to allow others to enter change orders. I would like to automate naming these change orders as Change Order 1, Change Order 2, Change Order 3, etc. 

I can use =COUNTIF([Entry Type]:[Entry Type],"Change") to obtain the number of change orders entered. How can I automate a column entry to auto-increment only change orders?

Adding or subtracting one doesn't suffice as it changes all entries. I believe it needs to take into account the created date or an auto-number column that could be referenced.

Thanks in advance,

Charles

Mehmet Zengin

Hi,

This should give you an idea.

Formula Column:

=COUNTIF($[Entry Type]$1:[Entry Type]1, "Change")

Entry Number Column:

=JOIN([Entry Type]1:Formula1)

J. Craig Williams

Good solution Mehmet

Craig

Mehmet Zengin

Thanks Craig!

Mehmet