WPS Last Modified By Field on Windows: Introduction

WPS Last Modified By Field automatically records the latest editor for each row in a smart table data sheet; this guide covers 2 core tasks, with 2 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	2	Matches the number of rows in the How-to Index
Available without membership	2	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

Last Modified By Field is an auto-updating field in WPS smart table data sheets. It shows who most recently edited each record after a row is updated. You can add the field when creating a new column, and you can also define which changes trigger updates in field settings. This is useful for accountability tracking, change review, and collaborative record management.

Core tasks include:

Add a Last Modified By field to a table.
Set the update scope to all fields or selected fields.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office and access smart table data sheets
App version	It is recommended to use the latest version of WPS Office
Network	A stable internet connection is recommended for online tables and collaboration
Other	You need permission to view or edit the target data sheet

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation notes	Download and install WPS Office for Windows, then sign in and open a smart table data sheet
Post-install check	After opening the table, confirm that the + button is available on the right side of the header

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	WPS smart tables can add a Last Modified By field and automatically show the latest editor for each record based on the configured update scope.	Microsoft Lists and SharePoint lists include an auto-created Modified By column that shows who last changed an item.	Google Sheets can show cell edit history with the latest editor and time, but this is not a dedicated field column for each record.	Notion databases include a Last edited by property that automatically records the person who last edited an item.	Adobe Document Cloud provides document-level activity history, but not a row-level last editor field for table records.
WPS Advantages	Advantage: WPS presents the result directly as a structured table field and lets you choose whether updates are triggered by all fields or selected fields.	Compared with WPS: Microsoft provides a built-in last editor column, but the official page focuses on default list columns rather than configurable trigger scope for selected fields.	Compared with WPS: Google focuses on cell history review instead of a persistent structured field in a table.	Compared with WPS: Notion also auto-updates the last editor property, while WPS additionally supports choosing which fields trigger the update.	Compared with WPS: Adobe focuses on document activity history rather than record-level table tracking.
Official Source	—	List and library column types and options	View the edit history of a cell in Sheets	Database properties	How to view history of a document under Adobe Document Cloud Web UI

Overall Conclusion
WPS Last Modified By Field is well suited to structured table collaboration because it keeps the latest editor visible as a field in each record. Compared with tools that emphasize cell history or document activity, it is more convenient for ongoing filtering, review, and responsibility tracking inside a data table.

Use Cases

No.	Scenario	Suitable for	Main challenge	How this feature helps
1	Collaborative data maintenance	Team members	It is hard to tell who last updated a record after multiple edits	Add a Last Modified By field to show the latest editor automatically
2	Change review	Project owners	A record needs quick ownership tracing after updates	Use the field to identify the latest person who changed the record
3	Key-field tracking	Data managers	Only important field changes should refresh the editor label	Set the update scope to selected fields
4	Issue tracing	Operations and support teams	Abnormal data is difficult to trace back to the latest handler	Check the field to find the most recent editor quickly
5	Process collaboration records	Cross-functional teams	Responsibility changes are not always clear during handoffs	Use the field together with other business columns

Membership & Benefits

Free vs WPS Premium

Feature area	Free users	WPS Premium
Basic use of Last Modified By Field	✅ Available	✅ Available
Advanced tools such as PDF features	Some functions are limited	More advanced tools are available
Cloud space and multi-user sharing options	Basic allocation	Higher allocation or broader sharing options

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
You only need to track the latest editor in a data sheet	Free	This field can be used without membership
You also need more PDF, AI, or expanded collaboration tools	WPS Premium	A better fit for broader office workflows

WPS membership center: Subscribe now