Hi everybody,
hi create a text colum where i want to have a date in letters (es. march 2024)
My initial value expression is
CONCATENATE(INDEX(
LIST(
"Gen", "Feb", "Mar", "Apr", "Mag", "Giu",
"Lug", "Ago", "Set", "Ott", "Nov", "Dic"
),
MONTH(TODAY())
), " ", YEAR(TODAY()))
the expression it's true and in my google sheets return value mar 2024, but in the app value is 45352
i also tried creating a virtual column
TEXT([Month]) but result it's the same?
Where am i wrong
thank you in advantage
Solved! Go to Solution.
By any chance, your column type in your gSheet is set as number or automatic. Change it to "Plain text" and see if that solves the challenge.
By any chance, your column type in your gSheet is set as number or automatic. Change it to "Plain text" and see if that solves the challenge.
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |