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     www.energyefficientbuild.com.

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
https://docs.google.com/spreadsheet/ccc?key=0AryiH8y2wxZtdHhaeXJhR1dFMkJpaDB5LVpzVDBGcEE
 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