How to capture/log user/contact info in a cell after updating a different cell?

I want to be able to identify the user when changes are made to cells on the Sheet. I know there is the Activity Log. But I want to see that data on the Sheet. I also know that there is the Modified By column, but that picks up changes to any cell in that row.

I have a log that needs to have the status column changed by the Client, and I want to automatically record who made the change without the user having to make selections from a different cell/column.

Is there a workaround?

Find more posts tagged with

Sheets

Automations

Update Requests

Accepted answers

All comments

MichaelTCA

Hello @SJTA,

You can use an update request. Then you will always have an idea of who made the change because of who specifically received the update request.

Otherwise, it will depend on how many times the status will need to change. You can have a separate "archive" sheet entirely and add an automation to copy rows over to the archive after a change has been made to a status and create a report to group each task to visualize how many times the status changed.

Functions don't move or copy between sheets. You can set up a function in a helper column to copy the name of the last modified by, before the row is copied to another sheet. Then you have a hard record of the last modified by because the function isn't carried over so the name won't change every time the archive is opened. Only the text value within the cell will be carried over.

=LEFT([Modified By]@row, FIND("@", [Modified By]@row) - 1)

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.