mercredi 5 février 2020

Add email address to sheet once Google form is submitted

I have a google form where the user can choose 1 of 5 options, "Red" "Green" "Blue" "Violet" "Yellow" I want to be able to add an email address to a column when a form is submitted so that I can set up an easy mail merge.

For example David wanting 2 boxes from the blue team.

The "color -team" Name always comes in column "C". I want their group email to auto populate in Column "G" based on column > C3 would be "Blue" Then G3 would become "blueteam@gmail.com"

I am thinking this would be done with an array formula and the if-then sort of idea?

Any help or directions would be greatly appreciated.

Aucun commentaire:

Enregistrer un commentaire