I have a sheet that connects to several dynamic views. One one of the dynamic views, the (unlicensed) user enters their network ID. The sheet then grabs information from another sheet to pull in email addresses for the user and their manager. There is automation that is then supposed to send email summaries of the information entered by the user in the dynamic view.
If I "Run Now" the automation runs perfectly for each line (and to the whole sheet, as I found out last week, but that's a separate issue). If it's left to run as triggered by a change on the line (as the automation is set to do), then the emails are generally not going out.
This year's sheets and automations are a copy of last year's because that ran perfectly once I set it up to do what I wanted. This year, it's giving me a headache. Please help!