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?
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?
Hello,
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,
Christy
Attachments (1)
No comments:
Post a Comment