List Generator Expressions

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}

Curious about your use case? I assume its for dropdowns which is what I would use it for.

Just seemed like it’d be useful, so I posted. But you’re correct, dropdown options is what led to me think about it. I was writing things like this today for suggested values :


I know the feeling and the struggle of stuff like that. Got a table of nothing but every day between 2017 to end of 2021


You just stole a vote from another feature request. I don’t know which one yet… I’ll be back with my vote!


that should be worth 2 votes.


This could really help speed up time when you need to create a list of things.

I’ll admit… limited use cases that I can see; but in the few times where I had to generate a list similar to something like this, having a simple function where I could provide a range and it would fill in the middle of that range - sure would have been nice.

1 Like

excel and google sheet has similar function SEQUENCE.

It is ideal if the same function can be used in AppSheet too,
although the first argument is redundant.

SEQUENCE(1, length, start, step )

SEQUENCE(1, 11, 0, 1) = {0,1,2,3,4,5,6,7,8,9,10}
SEQUENCE(1, 2, today(), 7) = {2/3/21 , 2/4/21}
CHAR(SEQUENCE(1, 4, 97, 1))= {“a” , “b” , “c” , “d”}
SEQUENCE(1, 6, 0, 0.1) = {0,0.1,0.2,0.3,0.4,0.5}

Note: function char also to be implemented.

1 Like