Column GetYear()

Can i create new column that sets the year (only) based on an existing date column ?

It’s not possible in Glide, but you can do it inside your spreadsheet.

Let’s say the existing date column is written into column A.

In your column B, write this ARRAYFORMULA into cell B1.

1 Like

Thank You !!!

This might be coming soon :wink: …until then, use @ThinhDinh’s solution

1 Like