Can I connect an auto-generated number to an email and link to separate sheets?
Our company is building out an event planning workspace.
We have one sheet that tracks the invitees/invitation history, and one sheet that tracks the information collected on the RSVP form for those who respond (via form) to the invitation.
When a person is added to the Invite sheet, there is a Guest ID generated for them.
We would like the Guest ID from the invitation sheet to be tied to their email so when a person RSVPs, their Guest ID will auto-populate on the RSVP sheet.
Is that possible? Is there a different/better way to have the same Guest ID from the invite sheet populate on the RSVP sheet?
Thanks for any help you can offer!
Help Article Resources
Check out the Formula Handbook template!