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

Google sheets function to get a list of all sheet names. This sheet names formula automatically generates a list of the google sheet tabs in a worksheet. Programming the automatically updateing index(array) of all the sheets in the workbook. How to use reference a sheet name in google sheets using simple code. I show the coding on how to get data from a cell in another sheet in google sheets using the indirect function google sheets.
💰 Join the members only chat room: / drawbridgefinance
📈 Purchase Custom Spreadsheets: www.etsy.com/shop/drawbridgep...
💰 All my links: www.linktr.ee/drawbridgefinance
▬ BROKERAGES I USE ▬▬▬▬▬▬▬▬▬
►Interactive Brokers: www.interactivebrokers.com/mk... (Paid Link)
►Wealthsimple Trade for CANADIANS: Get the cash equivalent of two free stocks my.wealthsimple.com/app/publi...
▬ Discount to Seeking Alpha Only $99/annually ▬▬▬▬▬▬▬▬▬
►www.sahg6dtr.com/2RSPJ5/R74QP/
▬ CONTENTS ▬▬▬▬▬▬▬▬▬▬
0:00 Intro to Google Sheets
1:10 sheetNameArray function make a list of tab names
2:14 Reference a Cell to Refresh the list
3:02 Edit the Apps Script
3:46 Variable value skip sheets
4:12 Indirect Reference a cell in another sheet
5:18 Reference another cell relative to the array
▬ GREAT FINANCIAL BOOKS ▬▬▬▬▬▬▬▬▬
► Unlucky Investor’s Guide to Options Trading(Pre Order): amzn.to/3ETWQpa
► Think and Grow Rich: amzn.to/2t285sL
► The Wealthy Barber: amzn.to/2sW9XTM
► The Millionaire Next Door: amzn.to/2HB6DTk
► Rich Dad Poor Dad: amzn.to/2y5rD4S
► Getting Started in Options: amzn.to/2LEJzWe
► Smart Couples Finish Rich: amzn.to/2Eu1qgr
▬ Trading Computer ▬▬▬▬▬▬▬▬▬
► LG OLED 48” 4k TV/Monitor: amzn.to/31lJPH8
► Samsung 28” 4k Monitors: amzn.to/32QZL4r
▬ Live Stream Gear: Video ▬▬▬▬▬▬▬▬▬
► Atem Mini Pro: amzn.to/3zRhJjA
► Glide Gear Teleprompter: amzn.to/3FSYnNl
► Elgato Stream Deck XL: amzn.to/3FMYV7t
► Iphone Lightening HDMI Adapter: amzn.to/3qLoVKh
► Joby GorillaPod (Bendy Tripod): amzn.to/3JsQ5xQ
► Manfrotto Tripod with Video Head: amzn.to/3bi67tr
-- As an Amazon Associate I earn from qualifying purchases --
Subscribe to Drawbridge Finance on RU-vid: ru-vid.com...
My primary investment strategy is long term high yield dividend investing, index funds and reducing risk and exposure using options. I have been actively trading the stock market for over 25 years and have built most of my wealth by reinvesting my dividends and following my 14 Personal Rules of investing. I actively trade options on both the American and Canadian Stock exchanges using options strategies and buying and holding high yield dividend paying stocks.
I generate monthly income in two ways. Averaging more than an annual 7% return by collecting dividends on high yield dividend stocks that I hold. The second income stream comes from the selling of option premium and taking advantage of theta decay. I love trading strangles, Iron condors and diagonal spread for maximizing returns. Delta neutral strategies allows me to make money in both bull and bear markets and limits my risk. Both of these strategies are suitable for passive income and create a stable predictable safe passive monthly income.
Want to learn how to trade stocks and make more money? This channel is dedicated to increasing investment returns and building wealth by passively trading in the stock market. If you’re tired of poor performance then make sure you subscribe to Drawbridge Finance ru-vid.com... I produce weekly videos for the beginner trader and use simple explanations to learn how I buy and sell stocks for profit.
Let’s Get Rich Together
Levi Woods
Disclaimer: I am not a financial planner and am not offering investment advice. This is an opinion channel only and should not be taken as any form of financial advice. I receive a small commission from the purchase of any item from using the links listed above. There are financial risks involved in taking on any monetary transaction that I discuss in my videos.
#investing #googlesheets #LetsGetRichTogether
The function is entered in the Apps Script and looks like this:
(It's impossible to post this fully here so it's missing the "less than, angled bracket" in the forth line of code between "i" and "sheets.length") but here is the code:
function sheetNameArray() {
var out = new Array()
var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
for (var i=6; i sheets.length ; i++) out.push( [ sheets[i].getName() ] )
return out
}