manually entered formulas

[John Scrogham]

I am linking my Goolge Form to the Google Sheet with a trigger set. I have a formula that I entered that calculates the amount owed based on the quantity ordered. When I copy and past that formula into the new column I created, it causes an email to be sent after the first person completes the form for each line that contains the formula, even if there is no other entries on the form. It only sends multiple it to the CC email and a copy of the Doc to the Google Folder it is assigned to. Is there a way to prevent this?

[Joseph Schmidt]

I'm not sure what part you want to delete. If you don't need the document why don't you use Formmule which sends in which sends email. I don't think there's any other controls. 

 You can instead use filter and I can't really step it is. 

Also I wonder about your formula how was it doesn't the form erase the line that has the formula you need to be using either way arrayformula or copy down add-on which is utility to copy of formula from one road to the next.

Joe Schmidt

On Thu, May 1, 2025, 7:18 PM John Scrogham <jscr...@jocombs.org> wrote:

I am linking my Goolge Form to the Google Sheet with a trigger set. I have a formula that I entered that calculates the amount owed based on the quantity ordered. When I copy and past that formula into the new column I created, it causes an email to be sent after the first person completes the form for each line that contains the formula, even if there is no other entries on the form. It only sends multiple it to the CC email and a copy of the Doc to the Google Folder it is assigned to. Is there a way to prevent this?

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/5f2df7de-856f-45b0-ad9b-4e98452a3433n%40googlegroups.com.