I have a team of 5 people in a company of 300. I would like to create a form that has a column which allows people to select from 2-3 people for that specific form (multiple or single people can be selected).
I would also like those people to be notified when they are selected on a submitted form.
If I make the column people (so that it notifies them) - it shows everyone within the space and not just my team.
If I make the column a list, I can’t figure out how to parse it using a formula so that it pings each person selected.
I’ve looked around and been unable to find anything that fits this specific problem.
The end goal is to have someone submit a form which alerts 2-3 people chosen on the form (preferably through an email).
Thank you for your help!
Edit: Apologies if this is a rather simple problem and I’m missing something obvious - I try to look around for a solution before hand but am not a programmer so sifting through formulas can be a bit challenging.