How do I automatically add time and date in column B and C of libreoffice calc, when I add any data in the column A?

[GaneshJ.Acharya]

ॐ
I need to know if any automation can be incorporated in LibreOffice Calc, using which, the time and date may automatically get added in the columns B and C, as soon as I add some data in column A.

[gtomorrow]

I thought this question sounded familiar! See here…

Calc automatic date on data entry

Hello all, Is it possible to automatically have a date entered in a cell when data in another cell is entered? Example: column A is awaiting data. If data is entered in say A4, I would like cell B4 to automatically enter the date of the data entry of cell A4, otherwise it would stay blank. Hope I was clear. Thanks in advance.