How do I set the date automatically in Google Sheets?

P

P

PreZz2020-09-10 13:56:42

Google Apps Script

PreZz, 2020-09-10 13:56:42

How do I set the date automatically in Google Sheets?

I want to set today's date in cell A1 with the value of the checkbox in A2 "TRUE"
Tried with different formulas, nothing happens (
Conditional formatting also failed (

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

D

dollar, 2020-09-10
@PreZz

=IF(A2;TODAY();"")

Similar questions

S

Scampy2018-05-08 21:44:59

How to change date format in script? 1Reply

A

arsenaljek2021-08-23 07:30:48

Google sheets JSON.parse by API. How? 1Reply

V

Vladimir Zuev2020-06-16 10:14:37

How to highlight a range in a table? 1Reply

V

Vladimir Zuev2020-07-02 08:38:56

How to create a table in a sidebar with a changing number of cells? 1Reply

G

Gamlex872020-07-15 11:37:34

How to bypass editing trigger at the same time? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question