Stupidest formula solution I've ever made (re: broken references)
Ya know how if you break a reference, it just doesn't recalculate the formula until you reapply it?
Well I have a sheet that gets duplicated for every new month through app script. In that process I have it delete certain pages and remake them off a template. But this breaks their formula link. And REF errors don't recalculate. You know what does recalculate?
rand()
rand() recalculates on every change. Every minute without a change if you set up your sheet that way. Enter my self-fulfilling prophecy:
If(rand()*0=0, do the formula...
Absolute nonsense and it works perfectly. Just thought I'd share in case anyone else found it useful.