I'd recommend using Apps Script for this, with a custom UI. http://code.google.com/googleapps/appsscript/
-Vic On Wed, Apr 13, 2011 at 3:42 PM, Kristel Ottis <kris...@gmail.com> wrote: > I'm trying to come up with a way to create a Google site where my > colleagues could review individual images (symbolizing projects), set the > status of a project from a drop-down menu and add a completion date using a > calendar selection (or even a text box, if that is too complicated). > Ideally, this drop-down selection to update my spreadsheet. Even more > ideally, I'd like for some projects to get highlighted as the completion > date approaches. > > Any idea how I could do this? I'm assuming it will involve customizing a > Google spreadsheet with a little bit of scripting, but I've scoured the web > for days now looking for a template or some kind of direction, but I think I > might be missing the right search terms. > > Thanks in advance for any help! > > >