Automatic job id number once enter a row
 

Hello

I'm working on a spreadsheet for a client that will be interactive via
the web. I would like for the job id to be automatically entered once
someone enters in a new row. Is there a way to do that?

Thanks!

Automatic job id number once enter a row
 

Hi

Say your job id's are currently until A300. Then, in A301:Ax you can
enter

=IF(B301="","",A300+1)

HTH
Kostis Vezerides

On Jan 25, 9:53 pm, wrote:
Hello

I'm working on a spreadsheet for a client that will be interactive via
the web. I would like for the job id to be automatically entered once
someone enters in a new row. Is there a way to do that?

Thanks!