Automated Emails are not coming from the Owner of the Sheet
I have a formula set up to identify when a target completion date is today's date. The Automation then checks to see whether or not the formula is displaying true or false and sends an Automated email to the assigned user. Normally these emails show me as the person that has sent the update because I am the owner of the sheet. However, the automated emails are now showing the name of the person who made the most recent change. I'm assuming whoever updates the field my formula is referencing is now the person who made the most recent change. I would think since I created the formula that I would be the person making the most recent change but apparently not. Is there some way to make it so the sheet owner is the only person these automated emails come from?
Help Article Resources
Check out the Formula Handbook template!