When a cell value changes, capture the contact name of who modified the cell value. This would be much similar to the record a date when cell value changes automation.
Hi @Joe_AM
Can you clarify how this would be different from the Modified By system column? Do you mean a static value based on only one cell change, versus any change in the row?
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Hi @Joe_AM
I hope you're well and safe!
Here's a possible workaround or workarounds
Please have a look at my post below with a method I developed.
More info:
Would that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
I echoe @Joe_AM 's need. I have a sheet that serves as a Strategic Plan base in which weekly status updates are to be provided by the manager. I had hoped to use the Modified by and Modified system fields to capture the date and time in which the Project Update was provided and then copy the row to a log that would store all the historical updates. I created a Submitted checkbox to serve as the trigger. Unfortunately, since the automation is the last action performed on the row, it captures automation@smartsheet.com instead of retaining the current user who modified the row prior to triggering the automation.
I have the same need. I have a cell in this case a drop down, that represent whether a sptep was approved, and I want to capature th person that appoved. I was thinking of an automation similar to Record a Date that caputere the current date, it would capture the current person that is modifying the specific cell.
Another approuch could be a last modified by function that takes as input the cell and get the contact of t he person that last changed the cell.
It is really annoying for the "Modified By" captured smartsheet cell-link@smartsheet.com or
automation@smartsheet.com. It doesn't really help to identify who is the real person that modified the record.
It would be great to see this option available since we use employee numbers for our email addresses. Since the content lives in the employee profile in Smartsheet, it seems like it should be available in a formula or some other way to capture.