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
Sur cette page du site, vous pouvez voir la vidéo en ligne Reference Data When New Sheet Created – Google Sheets durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Spencer Teaches Sheets 21 octobre 2025, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 38 fois et il a aimé 2 téléspectateurs. Bon visionnage!
