In my previous related question, I asked how to navigate to a certain column, however, now I also want to navigate to a certain sheet.
So I need a link from a cell, and by clicking it, I want to jump to the first row of a column (hardcoded in that cell) from a hardcoded sheet in that same sheet.
The code for navigating to a certain column is:
="https://docs.google.com/spreadsheets/d/1J-lBYHVVGjX1e8e_ZpeiNJIywJxfSW9waliWbJ2ICmM/edit#gid=0&range="& ADRES(1; KOLOM(D$1); 4)
I expect something like SHEET? should be added but that function does not exist.
What code is needed? Preferably I would use the NAME of the sheet instead of a number.