What activity counts towards the "Modified by" field?
This question was raised as a user with viewer access had it count towards the field.
Answers
-
Hi @sn7590!
The "Modified By" column shows the time each row was last edited and the collaborator who made the change.
For more information about this, see the following articles:
I also tested this and found that it worked as expected, users with Viewer access shouldn’t be able to make edits to sheets. To gain more insight, I recommend double-checking your sheet's Activity Log. It provides details about changes made and who accessed the sheet.
Additionally, it might be possible that your sheet contains a formula using the TODAY function. This function updates automatically when the sheet is accessed, which could explain why the "Modified By" column shows updates even when no manual edits were made. You can find more information about this function here: TODAY Function.
I hope this clarifies things!
Cheers,
Isaac.Need more information? 👀 |Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 |Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!