Adding a datepicker in Google Spreadsheet

Question

Is it possible to insert a datepicker in every cell of a column in Google Spreadsheet so that anyone can click (with a single click) on that cell and get a datepicker calendar to select a date?

Answer 1

if I remember correctly you can just set the cells format to date and that will have the same effect

I don't think there is a solution that will meet your exact requirements however you could use some conditional formatting to "cheat" the effect for example

have a default date of 01/01/0001 i.e a date what will never be entered by a user

then conditional format the cells to be font colour the same as the background of the cell.

This way when a user double clicks the cell it will show the date picker but will look like a blank cell until they do so, of course you will have to make sure your other formulas ignore the default date.

Answer 2

Right-click the selection you want to have the date picker show up for (i.e. single cell, entire row, entire column) and then open data validation. Set criteria to A valid date and click Save. Now just double-click the cell!

Edit: I missed the single-click requirement.

Answer 3

If you pre-populate the cell with a random date, double clicking will bring up the date picker;

http://docs.google.com/support/bin/answer.py?hl=en&answer=132459

Hope this helps