If my app uses multiple tables, e.g. 20 tables, I will need to use 20 separate sheet. That’s my current setup.
20 sheet seems to be wasted when some tables are only 1 or 2 columns holding a list (without the need to delete rows).
I know that relational databases work the same way, but I was hoping that a spreadsheet would use named ranges or columns, as separate tables (only when possible, when it’s a simple list).
If the app needs a dropdown list, can the list be pulled from a named range? Creating one dedicated sheet for 1 column and few rows, seems a waste.
Is it possible to use multiple tables within one sheet/tab? Can named ranges be used as a table, or as a list?