I would like a certain cell of mine to display today's date when I starts a new row.
Is it possible?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
You can use the =NOW() function inside that cell;
For todays date, you can use the following formula.
TODAY() formula provides the current date with no time component. It's better to use that, than to use the
NOW() formula. This will update on every edit made to the sheet, see reference.
Please realize that the value returned by the
TODAY() formula isn't permanent.
As mentioned by @Jacob Jan Tuinstra, TODAY updates automatically (so does NOW) and as I don't see the value of an entire column within which each cell always shows the current date, I interpret the requirement to be for a non-volatile solution. Hence suggest:
in the cell starting a new row. For such cells to be populated with the same result automatically would require a script with an OnEdit trigger.