The thing is very simple, I have buttons that redirect to different pages on the same doc… but whenever I make a copy to share to someone the link does not redirect to the same page inside that doc but it goes to the main doc where it was copied.
You should be able to solve this by linking to either a table or some kind of control in the other pages!
Say for example, you have a button in the homepage that needs to direct you to the finance page. In the finance page, you have a table called ‘Finance DB’.
In the homepage you’ll create a button, set the formula to OpenWindow(), and complete it by getting the dynamic link of the Finance DB table.
You can also do this with controls! Say I have a formula in the finance page, but no table. I can create a formula on the page, name it (in this case, Total Income), and reference it just like the table.
This will keep the correct links even when copying over to other docs, as long as the table/control comes along in the copy!