How can I add an item to the beginning of an Array?

Jacob Kofoed · 2024-02-08T14:19:33.966+00:00

I see there's an formula, but no ? I want to add the item to the beginning of the array. Is there something like that in the built-in formulas?

Jacob Kofoed
1 year ago
I see there's an Append formula, but no Prepend? I want to add the item to the beginning of the array. Is there something like that in the built-in formulas?
svenning
1 year ago
https://tenor.com/view/spider-man-we-one-gif-18212100
😂1
Erik Beuschau
1 year ago
You can use Concatenate 🙂
Jacob Kofoed
1 year ago
But with Concatenate I have to wrap it in an Array, right? I was hoping there was something similar to Append. I will use Concatenate for now.
Erik Beuschau
1 year ago
Yes, it must be wrapped right now
👍1
Erik Beuschau
1 year ago
You could also use Reverse+Append+Reverse 🔄 Or Reduce 😉
🤓1