Generate List Using Specify Number

AppSheet AppSheet Q&A
1

Hi guys,

Is there an expression to allow me to generate a list of numbers by specifying a number from another column?

Example:
Column_A = 10
List= [1,2,3,4,5,6,7,8,9,10]

I know i can use IF() but i wonder if there is a more elegant way? Even nicer if we can concatenate “OP”“[Column_A]”.

Thanks

2

WilsonWee:

Is there an expression to allow me to generate a list of numbers by specifying a number from another column?

Nope.

3

Hokay. Thanks much for replying

1 Like
4

Hi @WilsonWee, did you end up with a work around for this?

I have encountered the same scenario. My number range is not very large, so I’m thinking of making a table with the numbers 1 to 100 and then doing a SELECT(to produce a list of all numbers lower than the one in my other column).

Was your solution more elegant?

Stel

5

Stelio_Pappas:

I’m thinking of making a table with the numbers 1 to 100 and then doing a SELECT

Excellent idea!

2 Likes
6

Related feature request:

[List Generator Expressions](https://community.appsheet.com/t/list-generator-expressions/39376) Feature Requests

NUMBERLIST(0,10) = {0,1,2,3,4,5,6,7,8,9,10} DATELIST(TODAY() , TODAY()+7) = {2/3/21 , 2/4/21,… , 2/10/21} ALPHALIST(“a” , “d”) = {“a” , “b” , “c” , “d”} DECIMALLIST(0,0.5,0.1) = {0,0.1,0.2,0.3,0.4,0.5}

2 Likes