Issue with ARRAYFORMULA

I posted this question in StackOverflow, but thought I’d post here too in case there is an obvious answer from Glide experts.

My goal is to show a date like Oct 1 for posts posted in the last year, but use a longer format like Oct 2019 for older posts.

Hola @Malcolm_Lewis

You can use the new Format Date Column in Glide and have the Format as MMM y

Look at the picture attached!

3 Likes

Are they new? Love them! Opted for the Relative Option. Even managed to get 2d ago with a template.

2 Likes

Yes!

Check your GDE.:wink:

2 Likes

player0 has already replied in StackOverflow, but your issue with the arrayformula is that you used D2 instead of D2:D here.

=(IF(today()-D2 > 365
4 Likes

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.