Wednesday, May 23, 2012

yogi_Set Up A Computed Column For AutoNumbering XandRowNumber In The Form Responses Sheet

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #555    May 23, 2012

MALuisa.Sanchez said:
How to autonumber a column only if row has data on it? (Data came from a form)
Hi everyone ..
We are trying to experiment on google docs before we buy google aps for our business.
This is a link of a spreadsheet we are trying to come up with
 Spreadsheet is filled using a form.. I need to autonumber the rows in order to keep track of items added.  There is already a formula on Column B, but I would like it to NOT AUTONUMBER if the row has not yet been added (or filled)...
Can you make it happen?? pleaseeeeeeeeeeeeeeeeeeeeeeeee
following is a solution to the problem