“Last updated” column
Tracking when content was last updated provides visibility, accountability, and helps ensure the accuracy and timeliness of table content. In wikis, tracking the last update timestamp can help you prioritize your work and focus on entries that have not been updated recently. In other contexts, such as regulatory compliance or legal documentation, it may be necessary to track and document when entries were last updated. This can help ensure that all necessary updates have been made and provide an audit trail if needed. This tip walks you through creating a “last updated” column that will automatically update upon content changes.
Step 1: Create a new date column.
Step 2: Decide what you are tracking an update on.
Depending on your use case, you may want to know when the last time anything in the row was changed OR you may want to focus on the last time the content in a specific row was changed. Decide on exactly what you are tracking.Step 3: Create a column calculation.
Use the modified() formula chained to whatever object you want to track the update on.- To display when anything in the row was last updated, use
thisrow.modified(). - To display when a specific column was last updated, use
[column name].modified().
Was this helpful?
YesNo