CODEWITHSUNDEEP
google-sheets
Mr. B
Mr. B

Reputation: 2787

Display today's date in every cell in a single column in a google sheet

I'm trying to display the current date in every cell in a single column in a google spreadsheet. =today() displays the current date in any cell, but I can't figure out how to make it work in an entire column.

I tried =arrayformula(TODAY()), but it only works in the cell it's in.

Any ideas?

Upvotes: 1

Views: 32

Answers (2)

Grzegorz Mogilewski
Grzegorz Mogilewski

Reputation: 962

You have to make an array operation - any, to make Arrayfromula works, so eg:

=ArrayFormula(IF(row(A1:A),today(),))

will work

Upvotes: 2

Tom Sharpe
Tom Sharpe

Reputation: 34210

You need some way of introducing a condition on each row, e.g.

=ArrayFormula(IF(ROW(A:A),TODAY()))

Upvotes: 2

Related Questions