Auto Numbering Type Field

Options

Hi...

Is there a way to use a field set to auto number and also combine with inputting other numbers as well? I'm working on a ticketing project and some vendors use ticket numbers while others do not. I want to ensure tickets are all assigned a number whether it's auto populated or manually entered.

Thank you,

Debbie

Best Answer

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Options

    @dfortuna

    For the vendors that use ticket numbers, give them a column for that. For the vendors that do not use ticket numbers, create an auto number column for that.

    Then create a Ticket Number Helper column with a simple formula that says if the manually entered ticket number is blank to use the auto number ticket column. Then you'll always be looking at the Ticket Number Helper column which gathers the manually entered and auto number ticket numbers together into one place.

  • dfortuna
    dfortuna ✭✭✭✭
    Options

    Thank you for the information. Can you please provide a sample formula?

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

    @dfortuna

    =IF(ISBLANK([Vendor Ticket Number]@row), [Ticket Number Helper]@row, [Vendor Ticket Number]@row)