RedditPP Mascot

RedditPP

r/googlesheets • … • u/Grantoid

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.

— 0