Can I make a cyclic string in google sheets?-CodePudding

In haskell one can make an infinite list with

f =
  let ones = "ones":ones
  in ones

Is there a way to do this in google sheets?

I tried searching, but I only could find examples of infinite scrolling in google sheets, not infinite strings.

CodePudding user response：

I don't if this is exactly what you need, but you can try with BYROW, like this:

=byrow(B:B,lambda(each,"This is the string"))

(Important, choose a range from another column than the one you want to fill, if not it will be cyclical)

CodePudding user response：

try:

=INDEX(IFERROR(SEQUENCE(ROWS(A:A))/0; "ones"))