Sequence, TEXTJOIN, JOIN, ARRAYFORMULA in Spreadsheet Formula
Status: Closed · Asked by spluniya on · 0 views
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.
Hey @spluniya
I am afraid to say that some conditional formulas might not work on the SpreadSheets Formulas. Though you can use some non-conditional formulas will work.