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.