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.
Sign in to see the current vote count, add your own vote, or leave a comment.
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?
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!
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.
Although we are extremely proficient when it comes to reducing load on our smartsheets (we use pivot, data mesh and data shuttle extensively), we still find ourselves hitting capacity limits (mostly because of the number of columns in conjunction with some pretty complex formulas). Breaking up data between sheets and…
As the smartsheet admin for Europe, it would be extremely helpful to be able to view all Automations / recurring emailed reports in one place as opposed to sheet level. It's almost impossible to ensure everything is working correctly / delete recurring emailed reports without this.
It would be extremely beneficial to have the ability to manually assign colors to individual projects within the Timeline View. Currently, project colors are automatically determined by the Dashboard Theme, which limits flexibility and makes it challenging to visually differentiate projects in a meaningful way. Allowing…
