This was amazing!! May I ask if I can add an IF formula to the FILTER formula. Say for example on my google form its "Yes, see you there." and "Sorry, can't make it.". And I want it to fill up as "CONFIRMED" for "Yes, see you there.", and "DECLINED" for "Sorry, can't make it.". What formula should I use?
This is perfect for guest list tracking for my wedding. Kinda fast on how you do it but surely information is on point. Thank you for this tutorial.
Glad its useful.
This was amazing!! May I ask if I can add an IF formula to the FILTER formula. Say for example on my google form its "Yes, see you there." and "Sorry, can't make it.". And I want it to fill up as "CONFIRMED" for "Yes, see you there.", and "DECLINED" for "Sorry, can't make it.". What formula should I use?
this is exactly what I was looking for, great tutorial. Thank you
Question- can you make it so that instead of sending to an email it sends to a phone number?
Mailapp just sends emails.
You make sense to me with my Excel background. But oh my goodness...you are just way too fast. I need time to process the formulas.
Sorry!
Way too fast to teach anyone anything. Sorry
You can change the speed of the video. Maybe it just shows off something cool. Hope you were at least inspired if not educated at all.