Reference Data When New Sheet Created – Google Sheets
You have a formula that references the same range of every sheet
You want to add additional sheets, and have those sheets added to the formula
How?
There isn't a built-in way to simply "reference every sheet," but with a script, a list of sheet names, and a MAP() function looping through those names, this is totally doable!
Here, the script itself makes a copy of the TEMPLATE sheet, renames it according to a user input, and adds the name to the list.
The formula used here is a double-map function: =MAP(A2:A11,LAMBDA(name,SUM(MAP(E2:E,LAMBDA(sheet,IF(LEN(sheet),SUMIF(INDIRECT(sheet&"!A:A"),name,INDIRECT(sheet&"!B:B")),))))))
Music courtesy of CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2
#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
https://www.facebook.com/profile.php?...
https://x.com/SpencersSheets
https://bsky.app/profile/spencersshee...
/ reels
I use Bandicam to record, Clipchamp to edit, and a Blue Yeti microphone
Donate on Paypal: spencer.farris@gmail.com
In questa pagina del sito puoi guardare il video online Reference Data When New Sheet Created – Google Sheets della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Spencer Teaches Sheets 21 ottobre 2025, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 38 volte e gli è piaciuto 2 spettatori. Buona visione!
