Record changes to only 1 cell

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.

Find more posts tagged with

Sheets

Formulas

functionality

Automations

Accepted answers

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.