“Last modified by” column
Tracking the last updater of a row enhances collaboration, accountability, and documentation. Knowing who last made updates can help prioritize work or follow up on specific rows, allowing you to identify active contributors or individuals who may have relevant information or insights related to the updates made.
This tip walks you through creating a “last updated by” column that will automatically update upon content changes.
This tip walks you through creating a “last updated by” column that will automatically update upon content changes.
Step 1: Create a new people column
Step 2: Decide what you are tracking
Depending on your use case, you may want to know who was the last person to change anything on a row OR you may want to track who changed content in one specific column. Decide on exactly what you are tracking.Step 3: Create a column calculation
Use the modifiedBy() formula chained to whatever object you want to track the update on.- To display who was the last person to change anything in the row, use
thisrow.modifiedby(). - To display who was the last person to modify a specific column, use
[column name].modifiedby().
Was this helpful?
YesNo