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. [image] …

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 Robert Test Project,Task,Project,Task,Combined A,siLxzsQURZK3QGl0Zhqg7w, yLz8ofPiQrC8Y6BYfpm.CQ,A,siLxzsQURZK3QGl0Zhqg7w,A - siLxzsQURZK3QGl0…

I appreciate your help. My first Array formula and it worked properly both in the Google sheet and Glide data. :blush:

You can check this out :smile: [image] Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help Hi, Today I will show you the script that can make copying formulas down work, when it does not work with …

I need help formatting a date as month

Ask for Help

ThinhDinh September 3, 2020, 12:31am 4

You can check this out

Topic		Replies	Views
Changing Data format in Glide Table Ask for Help	4	781	July 3, 2021
Google sheets date functions in Glide Ask for Help	3	360	December 4, 2020
Date format Feature Requests	14	2860	January 14, 2020
Dates in glide Ask for Help	2	439	October 3, 2025
Thank you for date format plugin Project Showcase	5	501	July 8, 2022

I need help formatting a date as month

Related topics