UPDATE: We had two conditions, one that would send an email based upon a column being 'Yes' another that would send an email based upon the column being 'No' - however, I didn't account for the fact that we would sometimes skip over the question, so the column would be blank. I've updated the automation to include 'Blank' along with the 'No' response in the column.
We are running into a situation where the automation on a sheet hasn't changed at all, but the email that should be receiving the notification is receiving some emails, but not all emails. It should be triggering every time a new row is added and we know it works because they received an email this morning with a new row item, but it hasn't worked a few other times. Any ideas on why this might be happening? I hoped to find the automations in the audit log, but it sounds like the automations are not being recorded in the log.
Thank you in advance!
