The Last Updated field is a read-only system field that is a default date field created with all new Tables. It tracks when records were last updated, along with the member who created it and the time.
The Last Updated and First Created fields are displayed in record footers but are available to display in views and saved views. They also can be used in formula fields. New records display the First Created information in the footer until it is updated. From then on, the footer will show the Last Updated information.
The footer includes a link to the Member Profile of the user who Last Updated (or First Created) the record. This way you can contact the teammate who last updated the record to obtain further information. There's no hiding work in SmartSuite!
The Last Updated field is a system-generated field. It cannot be duplicated, changed, or deleted.
Important Note: The date and time values are displayed in the time zone the viewing Member has selected in their user profile. Members can change their time zone by clicking Edit in the General Preferences section of their profile. Time zone defaults to the Workspace's time zone value, which is set in the Workspace Preferences section of Workspace Settings (in Workspace Administration). |
Customizing the field
Solution Managers can choose the following display format when configuring solutions:
Avatar
Date
Avatar and Date
Choose the Date Format as "Days Ago" or "Date". If the Date is selected, Solution Managers can opt to display the exact Time records were created.
NOTE: Since the Last Updated field is located in the footer of records, Solution Managers should adjust the default display options by adding the field to Grid View and modifying it from there.
Check out quick articles on Adding Help Text to fields.
Record Updates and Activity History
The Last Updated field is used to track changes in a record's Activity History. The First Created field is displayed at the top, and changes are logged every time a record is updated.
Watching Specific Fields
Our Last Updated field watches the entire record, but maybe you're just wanting to watch a specific field or set of fields to make sure the right person is taking part in their portion of the workflow at the right time. This is where our Formula field comes in to play with our LAST_MODIFIED_BY and LAST_MODIFIED_TIME functions.
LAST_MODIFIED_TIME
LAST_MODIFIED_TIME([Field])
Returns a date and a time when a value of the specified field was last changed.
Example:
LAST_MODIFIED_TIME([Status], [Priority]) → if Status was last updated on Oct 7 @ 5:00PM and Priority was last updated on Oct 5 @ 6:00pm, result would be Oct 7 5:00PM
LAST_MODIFIED_BY
LAST_MODIFIED_BY([Field name])
Returns a name of a member who last modified a value of a specified field.
Example:
LAST_MODIFIED_BY([Status], [Priority]) → if Status was last updated on Oct 7 @ 5:00PM by Brian Dollen and Priority was last updated on Oct 5 @ 6:00pm by Peter Novosel, result would be Brian Dollen
Note: You can also check out our Formula Formatting, Functions, and Operators shared view for the full list of all functions, their descriptions, and examples on how they can be used.
Related articles: