what is a google sheet page index? It’s like a cheat code for huge spreadsheets!
Here’s how I do it:
1. Make a new sheet called "INDEX"
2. List all sheet names
3. Use =HYPERLINK("#gid="&SHEETID(), A1) to auto-link them (Google SHEETID() script needed tho).
Bit advanced but SO worth it. Script help here: [LINK].
Here’s how I do it:
1. Make a new sheet called "INDEX"
2. List all sheet names
3. Use =HYPERLINK("#gid="&SHEETID(), A1) to auto-link them (Google SHEETID() script needed tho).
Bit advanced but SO worth it. Script help here: [LINK].
