I thought this would be simple, but I can't figure it out.
If someone types "completed" into A1, I want it to send an email to a specific email address.
Initially I set up a "completed" button, but it doesn't work on mobile. So I now just need it to send me an email when someone types in the word "completed".