capture name of cell modifier in a cell

Joe_AM

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.

Genevieve P.

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?

Andrée Starå

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: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

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!

Jim Rood

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.

WLD Strategic Plan Historical Record Automation.docx

Abraham Sanchez

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.

slkim

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.

Sanpfeif

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.