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