Hi,
I need help setting up a formula that pulls from text in other cells to create a customized message.
Context: parents are calling to set up appointments to meet with teachers for specific time slots. Once the appointment is set, Ms. John would select the student's name from a drop down menu (cells B3:C11) then send the parent a confirmation text. I'd like to have the text message auto-populated with the appointment information once a student's name is entered into cells B3 to C11.
For example, in the case of the parent of Leanna Smith having an appointment with Ms. John on Friday 11/20 at 1:30pm, the text in B13 will populate to read: "Meeting Confirmation: You are confirmed to meet with Leanna Smith's Reading Teacher, Ms. John, on Friday 11/20 at 1:30pm. Zoom link here: zoom.us/0000000000. Please be prompt so that later appointments aren't delayed. See you then!"
Appreciate anyone's help! Thanks in advance.
I need help setting up a formula that pulls from text in other cells to create a customized message.
Context: parents are calling to set up appointments to meet with teachers for specific time slots. Once the appointment is set, Ms. John would select the student's name from a drop down menu (cells B3:C11) then send the parent a confirmation text. I'd like to have the text message auto-populated with the appointment information once a student's name is entered into cells B3 to C11.
For example, in the case of the parent of Leanna Smith having an appointment with Ms. John on Friday 11/20 at 1:30pm, the text in B13 will populate to read: "Meeting Confirmation: You are confirmed to meet with Leanna Smith's Reading Teacher, Ms. John, on Friday 11/20 at 1:30pm. Zoom link here: zoom.us/0000000000. Please be prompt so that later appointments aren't delayed. See you then!"
Appreciate anyone's help! Thanks in advance.