Auto Numbering Type Field

dfortuna

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

Mike TV

@dfortuna

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

Mike TV

@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

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

Mike TV

@dfortuna

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