This is clearly essential for huge sets of worksheets, however, the page link approach can be much faster for navigating small number of pages. for a small number of tabs under, say 15-20 or so it is faster to link to pages or cells directly, but once coded you can reuse the code. And agree it's best to create a link back to your guide or ToC page on each sheet.

Super useful video. Thanks a lot!

@BootstrappingTools

Ай бұрын

Glad it was helpful!

The video shows how to create a script to make a table of links to specific sheet in sheets. Very helpful for large groups of sheets. I'd suggest taking it a step further and adding a link to each page or menu item that takes the user back to the index. Also, could you consider adding the index to a dropdown in the menu bar? Good presentation. Thank you.

@BootstrappingTools

Жыл бұрын

Ah yes, so much more we could do to spruce things up a bit more. Maybe this video warrants a part 2... 🤔 Thanks for the suggestion!

@SteBor-bb1st

4 ай бұрын

@@BootstrappingTools Did you record a part 2 to this one?

Sorry - I know this video is older, but I just tried the script to generate a TOC, and the script is executing just fine in Apps Script and shows me the results I want, but it's not showing up on the Table of Contents tab I created in my Google Sheet workbook. Any suggestions on making it show up there?

When I did this it asked me for permission and I said yes but now it is saying access denied and I do not have permission to view the info

@BootstrappingTools

5 ай бұрын

Do you have edit rights to the google sheet you're trying to use this on?

Script editor isn't under the tools menu?

@BootstrappingTools

Жыл бұрын

Try under the "Extensions" option in the menu bar

function generateTOC() { var ss= SpreadsheetApp.getActiveSpreadsheet(); var sheets = ss.getSheets(); var sheet_names =[] for (i=0; i var url = "insert your spreadsheet link here" + sheets[i].getSheetId(); var formula = '=HYPERLINK("' + url + '", "Link to Tab")' sheet_names.push([sheets[i].getName(), formula]) } console.log("sheet_names: ", sheet_names) var toc_sheet = ss.getSheetByName("Contents"); var toc_range = toc_sheet.getRange(1,1, sheet_names.length, sheet_names[0].length) toc_range.setValues(sheet_names) }

@BootstrappingTools

Жыл бұрын

Hm?

@omargarcia2806

2 ай бұрын

Thank you.

@BombasticVirus

Ай бұрын

@@BootstrappingTools how was you expecting us to get the code?