S
S
sasha3002016-08-15 12:30:37
Google Sheets
sasha300, 2016-08-15 12:30:37

How to make automatic insertion of the current time in Google spreadsheets when entering data in an adjacent cell?

Greetings!
I tried to write a formula like:
=ЕСЛИ(A8<>0;"=ТДАТА()";"")
But I got:
=TDATA()
7b2d1f4b06654b5d95e0ea7465f805f1.jpg
If I write separately in the cell: =ТДАТА(), then the time is entered correctly, but in the formula there is some kind of ambush
Which way to dig - hz, thoughts are over :(
Thank you in advance for the answer!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
L
lvv85, 2016-08-18
@lvv85

If the condition is met, then the string -> "=TEDATE()" is displayed. To display the time, change the formula:
=IF(A8<>0;TODATE();"")

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question