Google Sheets: Get List of all Sheet Names and Reference Cells on other sheets

[@patrickkeene702]

Your script to reference the sheet names is amazing, thanks for being a life saver!

[@DrawbridgeFinance]

Glad it worked for you!

[@jacksonhoneycutt]

This was the final piece of the puzzle to compile stats for a tennis score sheet I was making. Thank you so much!

[@neatorinde1]

thank you so much for posting this. did exactly what I wanted, once I figured out I was missing the < portion of the formula that I cut a paste!!!

[@DrawbridgeFinance]

Glad it helped

[@jamesbaumann9691]

Thanks for the education, Levi. I've been using your sheets for the last couple years and they have helped tremendously. Look forward to the new sheet every month as a Patreon. Totally worth it just for the sheets alone.

[@DrawbridgeFinance]

Thanks James!

[@AnaLucia262]

Thank you for sharing this! It will save me a ton of time!

[@DrawbridgeFinance]

Glad it helped.

[@Harpeth_Internal]

This is great! Is there a way to add a link next to the tab name that will take the user to the tab?

[@mariovelasquez1265]

Thank you very much for your help! really informative video!

[@DrawbridgeFinance]

Glad it was helpful!

[@Prism684]

Amazing. Thank you

[@DrawbridgeFinance]

Glad you liked it!

[@0netom]

@5:47 in my experience =INDIRECT(B4 & "!$E$13") would also work; no need to fiddle with the single quotes. if you are just constructing a single cell reference or range, i don't think omitting the single quotes would make any difference, because the expression is still unambiguous. maybe if u name your sheets like cell references, like A1, A1!A2 or R1C1, it might be misunderstood, but i just tried and this still works: =INDIRECT("A1!A2!B1") if i have a sheet called "A1!A2"

[@DrawbridgeFinance]

Thanks for that!

[@MrChumBuddy]

this is exactly what I'm look for! Also, is there a way, let say to use an arrayformula to display the data so that I don't have to copy the same indirect formula into every cell? I tried to do it but it doesn't work...

[@DrawbridgeFinance]

I don’t know of a way but you can just pull the formula down to copy it into every cell in a column.

[@jhonnyaguilar1128]

Thank your so much!!!!!

[@DrawbridgeFinance]

You're welcome!

[@irapture9809]

Is there a way to pull the names from a different Google Sheet?

[@JorgealonsoDELGADO-kt3km]

Thank you so much man!!

[@DrawbridgeFinance]

Happy to help!

[@DrawbridgeFinance]

💰 Join the members only chat room: www.patreon.com/drawbridgefinance 📈 Purchase Custom Spreadsheets: www.etsy.com/shop/drawbridgeprops 💰 All my links: www.linktr.ee/drawbridgefinance

[@CNBarnes]

This is EXACTLY what I was trying to do ... up to the 5:55 mark. In your demo, you "fix' the target cell. I am wanting to fix the sheetname. Specifically, in my spreadsheet in cell C3, I have the "sheetname(2)", which puts the name of the 2nd tab in my worksheet. Then down in cell A3, I have =indirect("'"&$C$1&"'!A3") This perfectly pulls in the data from cell A3 of the tab named in cell C1. Where this falls apart is when I try to copy A3 to cell A4. What I want in cell A4 is =indirect("'"&$C$1&"'!A4") . But what I am getting is *exactly* the same thing I put into C3. In other words, it's not "advancing" the cell reference. Is there an "opposite" to using the $ in an cell reference to FORCE it to be relative when copied?

[@DrawbridgeFinance]

I’m not sure how to get the exact formula to change as you requested but you can use indirect with ranges to pull multiple cells which may help in your situation. =indirect(C1&”!A1:A2”) is a single formula that will fill two cells at once and the range could be expanded: A1:A10 or massive amounts of data with no ending row: A1:F

[@hxjdjdn6236]

Is it possible to get the values as clickable links to jump to other tabs/cells?

[@DrawbridgeFinance]

I wish that was possible also.

[@hxjdjdn6236]

@@DrawbridgeFinance i have managed to do it but it was not straight forward 😅

[@DrawbridgeFinance]

@@hxjdjdn6236are you able to elaborate?

[@ankitp7191]

Is it possible to have sheet names displayed horizontally instead of vertically?

[@DrawbridgeFinance]

Yes. Watch the short videos I post.

[@chem22691]

Hello. I've been using your script for about 5 months now. But for some unknown reason, it already stopped working. I'm getting an error message and couldn't seem to find out what's causing it. What could be possible reasons that the code stopped working all of a sudden? Thank you.

[@DrawbridgeFinance]

With no change it just stopped? I would try adding a blank line of code in the script so it’s changed without actually changing it. Save. Then run again to see if it works again.

[@benjaminhilsdon2238]

This function does not appear for me, do I need an extension?

[@DrawbridgeFinance]

This is not an extension. I walk through The entire process. You may just have to watch the video again as you likely missed a step.