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!
