Sequence, TEXTJOIN, JOIN, ARRAYFORMULA in Spreadsheet Formula

[spluniya]

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.

 

[Supreme]

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.

Spreadsheet Formulas inside Pabbly Connect | Pabbly

Pabbly Connect supports tons of Spreadsheet functions. Most of the functions supported by Excel or Google Sheets can be used directly inside Pabbly Connect.

www.pabbly.com