I linked to my Google Sheet, using Script Editor, javascript code that makes the sheet jump to the row that contains today's date. However, the jump to today's date row feature only works for people who have edit access to sheet. I already deployed the JS file as a web app, but people with view only access using a link still does not see the effect of the code. How can I solve this problem or employ some sort of work around? 
Shared publiclyView activity