Hi
I expect that this issue has come up before!
I am trying to find a way to get notifications when a user accesses a Google sheet that I have shared with them.
For example, I can make the sheet only work if the user enters today's date. This works as, as soon as they enter in today's date, 1) the sheet works and 2) I get a notification showing that a user has made an amendment.
However if a different user accesses the spreadsheet the same day, the date entry will still be correct and hence the spreadsheet will work straightaway and I can't then see that they have accessed it.
Be interested in any thoughts or solutions!
Thanks in anticipation.
Bookmarks