I am trying to figure out how I can use an extension or perhaps create a widget that allows me to test the contents of a variable when a sheet loads and then navigates to a different sheet based on the SheetID if the variable has a specific value.
So in practice it would work like this:
Sheet A contains a variable called DownFlag
When the value is set to 1 the sheet will automatically navigate to a different sheet in another app (SheetB) that has a message stating: Under Construction.
When the value is set to 0 nothing happens.
I want this to be automatic.
I want to be able to reuse this method on any sheet that I have created the DownFlag variable and included the proposed widget to handle it.
