Any function equivalent to ARRAYFORMULA in GSheets?

Ask the Community
#1

I’ve searched this forum but there seems to be no discussion about having an ARRAYFORMULA function. Appreciate it if anyone knows if there’s any solution available, or do I have to copy the formula across all rows. Thanks!

J

1 Like
#2

Hey @Joshua_N :wave:t4: thanks for reaching out. We don’t have the ARRAYFORMULA function in Rows yet but we should be able to accommodate your need to automatically copy the formula across all the rows using our FILL function.

Here’s an example —

FILL

Hope this helps and please feel free to upvote this as a feature request ask on our public board here —

Should there be anything else we can help with, please don’t hesitate to write back :innocent: