google

Work

Google Spreadsheets Can Validate Data

12:00AM Kevin Purdy | If you’re sharing or collaborating on a Google Spreadshet, you can now set columns to validate data types. Cells can enforce certain data types, require valid URLs or mandatory text, for example. [via Google Blogoscoped] More »

Google Spreadsheets Adds Gadgets and Autocomplete

12:16AM Gina Trapani | Google rolls out a few impressive new features to its online spreadsheets offering today, including cell autocomplete, iGoogle gadgets, and notifications about collaborative edits. Autocomplete works the way any desktop spreadsheet does: as you type, if the cell contents match a past entry, Spreadsheets will suggest the value. As for data collection and sharing, you already know you can ask others to fill in a spreadsheet with a user-friendly form. Now you can get notifications whenever a sheet gets updated, down to a specific range of cells or via a form. Finally, you can track the status of your spreadsheet on your iGoogle homepage by creating a data widget, which updates as your spreadsheet does. Pretty nifty. Google Spreadsheets Adds Gadgets, a Directory of Features [Google Operating System] More »

Enter Data into Google Spreadsheets via Custom Forms

10:38AM Gina Trapani | Google adds an interesting new feature to its online spreadsheets product: the ability to create and share an entry form with others for collecting information (versus giving them full access to the spreadsheet itself). Looks useful for surveys or any kind of easy information collection for a large number of people. Now that you don’t have to be a Gmail user to use Google Docs (and Spreadsheets), it’s open to everyone, too. To make a form for a spreadsheet, in the Share tab, check the “to fill out a form” option under “Invite people.” Stop sharing spreadsheets, start collecting information [Official Google Docs Blog] More »