I thought I set up a very simple automation but it doesn't work even after trying variations. I just want to send an alert when an entry in one cell changes. I set up a column using Yes and No options (default is blank) so that when someone chooses Yes it would alert me (I'm only using my own email address while testing/learning). I've tried over many days to change various cells to Yes, and to alter the automation formula a bit, but have not yet received an email.
I also set up a column using check boxes to alert me when it changes to checked, but that hasn't worked either. Obviously I'm missing something in the automation tool! How can I make this work? Thanks!!