So I have a sheet that has a form attached to it. We use this for our sales reps to enter sales, for an order entry person to enter them in. With this, we built automations to alert/email the order entry person of a new sale.
While multiple sales reps enter orders, there are times that the FROM address shows the registered smartsheet user; and other times it appears it is coming from me - due to me being the sheet owner.
How would one diagnose WHY it is coming from me sometimes, and coming from the entering rep at other times? I have examples that show almost the same exact items, and is part of the same automation - but 1 shows me (sheet owner) and the other shows the rep. What gives?