Google sheets filter not functioning on mobile

I am trying to make a calendar also automates a to do list. (why we are doing this in google sheets and not an app that does so easily for free is an excellent question that I have no answer to. Like Mongo I am just a pawn in the game of life.) so have been the doing the dumb old cell = correspondent cell on the calendar and a filter to only display the cells that have actual info. so I've been using this code to continually refresh my filter here https://medium.com/google-cloud/automatically-refreshing-basic-filter-on-google-spreadsheet-using-google-apps-script-e9728826bbd8 . This works great on computer - filter instantly updates, all that good stuff. The problem is that is doesn't work on Google sheets mobile. It will change already displayed data just fine but not display anything else added to calendar without manually refreshing to the filter. Any tips on fixing this would be greatly appreciated. Note, I have tried the () filter function, but it doesn't quite suit my needs. To see the the worksheet in question (https://docs.google.com/spreadsheets/d/1s0K2wWvC9JI4WF1xrtOhVsrsapXR7ELdH-dPooVeq6E/edit?usp=sharing) Please let me know if this isn't the right spot. I've already be bounced around a few communities by other users trying to figure out the right one for this oddball question.