Forum Discussion
Create Table with Generateseries() and a String Value
Dear community,
the problem seems simple to solve, somehow it doesnt work as planned.
What I want to achieve is the following. I want a table with the following Cells
--------------------
"Please select"
1900
1901
1902
...
2022
--------------------
What I already have is:
Table = GENERATESERIES(1900, 2022, 1)
So I just need to add "Please Select".
The data type should be "Text" for this table.
Any ideas? I know it should be actually easy...
Best regards and many thanks in advance,
Phil
Anonymous Try:
UNION( GENERATESERIES(1900, 2022, 1), { "Please select" } )
1 Reply
Anonymous Try:
UNION( GENERATESERIES(1900, 2022, 1), { "Please select" } )