Forum Discussion
Adding today's date in date column in new row of a table
I have a date column in a table that has manually entered dates. I am wanting to utilize a formula to add the current day's date in the date column when a new row is added to the table. I would like ...
Hi, you could try the following. Assume that your new row is row 12. If an entry is made in column A, the value in column K, i.e. the date in K12, should be fixed.
Then you have to write in K12:
=IF(A12="",TODAY(),K12)So the cell refers to itself and is therefore no longer updated.
Don't forget to allow Iterative Calculation in File > Options > Formulas.