Formulas Parameter Not Copying Formulas with New Submissions

[Rosemary L]

First, thank you Henrique for creating this script! It is a huge lifesaver for my school and is going to prove to be very useful.

I have setup my spreadsheet to lookup two different email addresses (which have been removed for security purposes) on the Lookup sheets. These formulas are located in cells N2 and O2. Formulas in P2 and Q2 assist with the lookup process. Cell M2 is just for me to verify that the lookup tables are looking up the proper email addresses.

Here is the spreadsheet for your reference:
https://docs.google.com/spreadsheet/pub?key=0AmCFoNMwzTx0dHd3cHpzZGc1cUtLOGpaQ0hZWGlKQ2c&output=xls

My formulas are working perfectly. And, I will be able to put the Placeholders for those columns into the To: field in my email templates. I don't have any problems with my formulas or setting up my To: fields.

My problem is that when a new form submission is received, the formulas in columns M to Q do not automatically copy down to the new row that is created.

My FormEmailer settings have the following settings:

Formulas Location: Nominations!M:Q
Closure Mode: formulas (I plan to change this to values to speed up the spreadsheet, but for now, while I'm setting everything up, I'd like to see the formulas)

And in case you need it, here is the form:
https://docs.google.com/spreadsheet/viewform?pli=1&formkey=dHd3cHpzZGc1cUtLOGpaQ0hZWGlKQ2c6MQ#gid=0

I've read the Advanced Settings page and I've read quite a few responses in this Discussion Group. I've tried to research a solution on my own, but I just can't figure out what is causing these formulas to not copy to the new rows.

Thank you so much in advance for your help with this problem!

[Rosemary L]

I just wanted to follow up on this question. Can anyone help me?

I'm truly at a complete stand-still right now b/c I can't get the formulas to copy. My form is truly worthless if I can't get the formulas to work.

[Henrique Abreu]

Hi Rosemary,

Your setup seems to be ok. On your tests (which I don't see on this file), does the emails get sent and the formulas are still not copied down?

I ask because the formulas are only copied when the row is processed, if it's processed automatically, then they will only be copied when you actually pick "Process Manually" on the menu.

Regards,

Henrique Abreu

[Rosemary L]

That makes complete sense now! It does work when I process it automatically. Perfect!

Thank you so much for the script again. It is exactly what we needed.