I have an issue where my permalinks become useless after midnight.
I create a bunch of permalinks to the rows in my main sheet. At midnight I move all these rows to an "Archive" sheet. Is there a way for the permalinks to reference the row that has been moved?
Anyone else have this need?
I had thought about renaming the main sheet and creating a fresh one but then anyone linking to the main sheet has to fix their link/bookmark/favorite.