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.
={"Year";ARRAYFORMULA(IF(A2:A<>"",YEAR(A2:A),""))}
1 Like
Thank You !!!
This might be coming soon 
…until then, use @ThinhDinh’s solution
1 Like