Record changes to only 1 cell

Emerys M

In a sheet where another user and I download files and mark them in different stages (proofed, processed, uploaded), is there a way to record who last modified a cell rather than a whole row? I'd like to have a cell automatically record who changed which phase. I know that I'm able to right-click a cell to see its history, but I want a way to review multiple cells easily without having to dig through the activity log to do it.

Anupriya

You can use the Smartsheet automation - Record a Date. In this automation, you can define the cell which triggers this automation to record the date when the change was made.

Set the Current Date with Record a Date Action | Smartsheet Learning Center

Emerys M

Yes, we have the Record a Date workflow set up, but that doesn't mark which user changed the cell. I'm looking for the equivalent of "Modified By" that will only update when a specific cell is changed instead of recording changes for the entire row.

Andrée Starå

Hi @Emerys M

I hope you're well and safe!

To add to Anupriya's excellent advice/answer.

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!