Creating MONTH YEAR Column

[Louwrens]

I am trying to create an expression of Initial value that will tell me this specific row was create MONTH | YEAR (November 2020).

I currently use, and have been using 2 columns:
Month | Year

This I have achieved through

INDEX(
list(
“January”,“February”,“March”,“April”,“May”,“June”,
“July”,“August”,“September”,“October”,“November”, “December”),
MONTH(TODAY())
)

But I would like to merge them so that I can create Month Graphs from now on group into years aswel.

Can anyone assist?

[Rafael_ANEIC-PY]

Hello Louwrens, i believe you could concatenate both of your desired values into a single column, that expression would look as follows:

CONCATENATE(
INDEX(
list(
“January”,“February”,“March”,“April”,“May”,“June”,
“July”,“August”,“September”,“October”,“November”, “December”),
MONTH(TODAY())
),
(Your “Year” column expression goes here) )

OR

Summary

INDEX(
list(
“January”,“February”,“March”,“April”,“May”,“June”,
“July”,“August”,“September”,“October”,“November”, “December”),
MONTH(TODAY())
) & (Your “Year” column expression goes here)

[Louwrens]

Thanks Rafael,
Is working as I hoped.

CONCATENATE(
INDEX(
list(
“January”,“February”,“March”,“April”,“May”,“June”,
“July”,“August”,“September”,“October”,“November”, “December”),
MONTH(TODAY())
),
(YEAR(TODAY())) )

[Steve]

Try:

TEXT(TODAY(), "MMMM YYYY")

See also:

help.appsheet.com

TEXT()

Format as text

[Louwrens]

Thanks Steve,

Works great

[Louwrens]

When I look at the view after logging this column it shows 44136 but, in my sheet it states Noverber2020.

What could the reason be? My Row type is on text.

[Steve]

Please post screenshots of the view showing the improper value, and of that column’s configuration screen from the app editor.

[Louwrens]

Steve:

improper value

[Steve · Accepted solution]

The Month Year column appears to be a regular, non-virtual column. The value of a regular column is only recomputed when the row is edited or when the row is changed by an action. If this particular row had a value in that column before you applied the new expression, you will need to re-apply the expression.

I would encourage you to move the expression out of Initial value and into App formula. After saving that configuration change, go to the app, open the row in a form, save the form without making any changes, and observe the value should be corrected.

[Louwrens]

Please Correct me if I did it wrong but, it is still doing the same?

[Suvrutt_Gurjar]

You may wish to ensure that the “Month Year” column in the back end spreadsheet is of “Plain Text” type instead of type "Automatic’ that is default many times.

If you are using Google sheet the option is available under Format – > Number

[Louwrens]

Thanks Suvrutt,

It seems like it 100% now.