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