'Send from Triggering User' sending from Sheet Owner instead of 'Triggering User'
We have a feature request form that anyone in the organisation can populate. The Sheet is shared to a number of admins that work on tickets and send out communications on updates.
Automation is setup so that when the 'comments' column is updated, the person who wrote the ticket and the admins are updated via email using 'Send from Triggering User'
This works *some* of the time, other times the triggering user is defined as the Sheet owner (Me) instead of the admin that updated the comment cell