It is good to see google attempting to supply data validation on the cells of a spreadsheet. See details here:
http://googledocs.blogspot.com/2009/02/data-validation-gives-you-more-control.html
However it’s only a first start. In my spreadsheet demo yesterday the input for employee tax status could not have been validated. As one person mentioned google’s text validation is more like a check off box. Either the text matches exactly one string or it does not validate. There’s nothing equivalent to a pick list. How long will it take Google to supply a pick list? Or for that matter to verify the numeric dollar amount is withing a certain range? I bet it won’t be long. The question is why did they not include these validations in their first release?
I agree, why no picklist? It seems ridiculous to not have that.
Comment by John — September 1, 2009 @ 1:51 pm