I have a list of projects with dates. I would like to filter the items shown by their year, e.g. 2019, 2020…
I assume the best way is to create a new column in the data sheet. However, I cannot work out how to extract the year. The If, then, else function should work since it recognizes dates but I can’t set up the arguments.
I know the workaround is to add a column in my google sheet and use Year() but this means I have to copy down the formula a thousand times, just in case my project list grows and grows.
Isn’t there a way to extract the year using a new data column?
If you want to keep it all in Glide, I think you could probably create a split column that looks at a Date column in Medium format. This could split that date column at the comma, then you might be able to grab the 4 digit year value from there. I haven’t fully thought this through though… so I don’t really know how to do this in full.