Wednesday, January 11, 2012

yogi_Setup A Sheet To Allow Only One Entry Per Row

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user jmm666 said:
hi, i'd like to share a spreadsheet for other people to fill out so that only one entry per row can be accepted (this is a kind of "first come first serve") - this is easy to implement in excel (e.g. =COUNTA($B2:$G2)<=1 -> attached) but the formula is not exported to google doc, whose validation options dont seem to cover the request - any suggestion?
thank you
---------------------------
following is a solution tot he problem