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


  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    edited 12/09/20

    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?


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.