Sequence, TEXTJOIN, JOIN, ARRAYFORMULA in Spreadsheet Formula

spluniya

Member
We have a last digit number and want to sequence from 0 to last digit number with comma separated, for this all we can use the following formula

=TEXTJOIN(",",TRUE,SEQUENCE(7,1,0,1))

=JOIN(",",ARRAYFORMULA(ROW(INDIRECT("A1:A"&7))-1))

=SEQUENCE(1,6,1,1)

but these all formulas are not supported in pabbly spreadsheet formula so kindly incorporate these on urgent basis and also guide us how can we solve this problem.
 
Top