I have shared a spreadsheet, anyone having the link can see it. Since it is a spreadsheet I update daily, I want to facilitate the others recognizing the last changes. However, revision history is available only for collaborators which can edit the spreadsheet. Is there any workaround I can use to highlight the last changes when the others open it?
Google-sheets – Track changes in read only shared Google Docs
google docsgoogle sheetstracking
Related Topic
- Google Sheets Timestamp – Automatically Set ‘Last Updated’ Cell
- Google Sheets – Equivalent of Excel CLEAN() Formula
- Google Sheets – Move Standalone Chart to Existing Sheet
- Google Drive – How to Automatically Open Google Docs Above a Certain Age in Viewing Mode
- Google-docs – Date and time keyboard shortcut for Google Docs document (not sheets)
- Google-sheets – How to show thumbnails of images stored on Google Drive on Google Sheets
Best Answer
Protect the sheets of your spreadsheet, and add people that you want to see the change history as collaborators. See Protect a range or sheet from being edited for details.