9 апр. 2024 г. · =IF(I4,I4,IF(G4<>"",now(),"")) Now works but it only puts the date once, it won't update/change the timestamp if i change the value in the same ...

19 янв. 2024 г. · I have a formula that I'm using to get a static timestamp, however it occasionally re-updates for reasons beyond me. Am I going about this the wrong way?

9 нояб. 2023 г. · Looking for some help with static timestamping. I would like an automated timestamp at the end of each row whenever data is entered into a column.

30 сент. 2024 г. · I have 2 columns (w/ headers). I want a static date timestamp to be entered in C2 when B2 has something entered in it.

19 февр. 2023 г. · To get a static timestamp array, I use this and then copy it down to the rows I need: =lambda(x,y,if(y,x,))(now(),A2).

18 мар. 2022 г. · The now function cannot display a static time. I was wondering if there is a way to insert a static timestamp into a cell whenever a checkbox is marked.

Hello Guys,. I'm new to sheets, is there a formula in gsheets where i can automatically get the date in the next coloumn whenever the data is being entered ...

19 июл. 2024 г. · If your checkbox is in A2, then this formula will give you a static timestamp when it's checked. =IF(A2,LAMBDA(x,x)(NOW()),). If you just want ...

4 мая 2022 г. · You can change the format that you want displayed in the dropdown by using =TEXT(NOW(), "DDMMMYY HH:MM") (or any other format you'd like) where ...

27 сент. 2024 г. · LAMBDA(x,x)(now()) is great to return a static timestamp or a static version of any volatile function (RAND, TODAY,...). It's because of the way ...