I am trying to make a calender that 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.