Autonumber

David Rice

I am looking at the auto-number system, is there any way to have the id match another two columns?

Mark Cronk

Hi @David Rice ,

Setting column property to Auto-number gives you a couple options to customize the number generated. Picture below.

If you want to use data from another column(s) you can place a column formula into your ID Number column. To get auto-numbering you can combine this with an auto-number column. Your ID Number column formula would be something along the lines of =[column5]@row & "-" & [column12]@row & "-" & [auto-number]@row. If you go this route realize that if the data in the other columns is changed, the ID Number will change.

Any help?

Mark