Autofill to Today's date when I start a new task

Eric Jaffe

Trying to figure out a way to have a cell autofill to Today's Date when I start a new task.  Thanks!

Michael Bell

Try this IF THEN statement in a column that is a date column.  IF VALUE 1 (which is column named value row 1) is blank, then "" will return a blank, if not it will return today's date

=IF(ISBLANK(VALUE1), "", TODAY())

Stephanie Taylor

You could also rename the column to Auto-Number/System and check Created (Date).