Automatically adding the date/time to a cell when another cell is updated

@kovesp

Hi I have the same issue
my spreadsheet has steps and when a step is changed or edited another cell should reflect the date
and since i have many steps I need to see many dates to know when each step was edited

for example:
cells with content to be edited are :
J8, J14, J23,P8,P14,P23

and cells that should reflect changes date are:
I11,I17,I26,O11,O17,O26

So cell I11 should show the date when J8 is edited
(whenever J8 is edited, I11 should update the date)
and whenever J14 is edited, I17 should update the date (show the date),
and so on

I tried =IF(J8="","",NOW())
and I tried =IF(J14="",IF(I17="",NOW(),I17),NOW())
and tried =IF(ISBLANK(P14)," ",NOW())
and tried =IF("$P8"="","",NOW())
and =IF(P8<>"",IF(O11="",NOW(),O11),"")
all of them are working but with 2 problems:
- if i edit any cell in the sheet, the date is updated
- but it is updated in all the cells that contains this formula despite that the formula in each one has different cell number as referred above

any help is appreciated
thank you in advance