Tuesday, April 1, 2014

yogi_AutoGenerate Serial Numbers Based On Specified Prefix And Numbering Pattern

                                         Google Spreadsheet   Post  #1585
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-01-2014
post by Christy McKenzie (https://productforums.google.com/forum/#!mydiscussions/docs/AO6nxiORTOQ)
Can I auto-generate serial numbers based on the text value in another column?

I need to create serial numbers based on text in a column with a "data validation" drop down. See attached - I made a copy of my worksheet to monkey with.

Each option in data validation has it's own starting number, and I need each new row assigned to generate the next number in its series. The fields included in the data validation drop down, with the serial start numbers are in a key at the top of the spreadsheet.

Thank for any help,
Attachments (1)

Offer Codes Assigned by Hopster.gsheet
205 B   View   Download