How do I automatically update a URL in Google Sheets? or What's the easiest way to update a URL in Go

Ever tried "=HYPERLINK()" with a dynamic formula?

Not *fully* automatic, but if you pair it with a cell that holds the base URL (which you update), all linked cells will reflect the change.

Kinda hacky, but zero coding needed!