Is there a way to exclude Automation from changing Modified By?
Hey all! We use Smartsheet to record all of our records for our clients. We use the Modified By column to keep track on who last touched the cell so if there is any questions that come up we know who to go to.
I tried to setup a automation for recording dates when a column says a specific text. IE when column "Status" = lost connection then record today in column "Status Changed Date". But with using this automation it is changing our Modified By column to [email protected] rather than the user that actually modified the cells.
My question is, is there a way to not include the automation user in the Modified By column? If not is there another way I can accomplish what I was trying to do with automatically adding dates?