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
En esta página del sitio puede ver el video en línea Reference Data When New Sheet Created – Google Sheets de Duración hora minuto segunda en buena calidad , que subió el usuario Spencer Teaches Sheets 21 octubre 2025, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 38 veces y le gustó 2 a los espectadores. Disfruta viendo!
