I would like a certain cell of mine to display today's date when I starts a new row. Is it possible? 
Pre-fill a cell with today's date
google spreadsheets
You can use the =NOW() function inside that cell;http://docs.google.com/support/bin/answer.py?answer=82712&version=static#section_Date