I have hundreds of text strings entered through a form in a Google Spreadsheets which look like 4*3 9*2 17*3 22 37*4 52. I can easily substitute " " for "+" and concatenate a "=" in front =4*3+9*2+17*3+22+37*4+52. Now I have a text string which looks like a formula but isn't one. How can I make Google Spreadsheets interpret this string as a formula? [more inside]
posted by Akeem on Mar 12, 2009 - 3 answers

I want to be able to filter my data in Google Docs Spreadsheets like the Data > Filter > AutoFilter function in Excel 2003. [more inside]
posted by Jacqueline on Oct 7, 2008 - 1 answer

I am looking for a way to sort embedded Google Spreadsheets. I am not looking for advanced features or interacting with the data, but ONLY client side sorting. [more inside]
posted by joemako on Aug 11, 2008 - 2 answers

Let's say I have a two column chart, with the following values: [more inside]
posted by underdetermined on Apr 29, 2008 - 10 answers