I need help formatting a date as month

[darder]

Hi everybody

I need some help about how to format a date MM/DD/YYYY HH:MM in a new calculated (Template??) column which show the MMMM for every single row.

I put an example of what I mean using the google sheet but I need to get this conversion on Glide to obtain the result in new rows.

Thanks

[ThinhDinh]

You can put this in your F1 cell.

={"Month";ARRAYFORMULA(IF(E2:E<>"",TEXT(E2:E,"mmmm"),""))

You can see the example here.

ThinhDinh's Glide Lab

[darder]

I appreciate your help.

My first Array formula and it worked properly both in the Google sheet and Glide data.

[ThinhDinh]

You can check this out

Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts

Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job.

1/ Definition

Arrayformula is defined as “a range, mathematical expression using one cell range …