Switch

[Máté Simon]

How can i set wich tab to run the formula on?

[Joseph Schmidt]

I don't think you can change the sheet from the Form Responses sheet.

You can use an Arrayformula or BYROW to have one formula populate all of the rows.

See the video in my channel

Joe Schmidt

https://www.youtube.com/c/JoeSchmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

On Fri, Jun 28, 2024 at 6:03 AM Máté Simon <simon...@gmail.com> wrote:

How can i set wich tab to run the formula on?

--
You received this message because you are subscribed to the Google Groups "NV Copy Down Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-copy-down-ad...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-copy-down-add-on/a76dbe9c-e353-4d6d-8e36-be76dcd367f3n%40googlegroups.com.

[Michael C]

Hi,

Only if you have multiple forms submitting to the same workbook, if you submit a form on the sheet tab you want you can add copy down but only on sheets with a form submission, if you want to make changes to your original sheets copy down you must submit a new form to the first sheet and it picks it up when you load copy down

I have this on a number of sheets each linked to a form, if I don't have it linked to a form, like Joe suggested arrayformula normally does it

Mike