Is there a way to reference an entire spreadsheet with a cell reference in Google Sheets?
Say I wanted to find out how many cells in Sheet1 were non empty. In sheet two I'd want to do something like
I've tried some common sense things like just using a colon e.g.
Sheet1!:, but that doesn't work.
Alternatively you can do something like
Sheet1!1:1000 but obviously this misses an "infinite" number of rows or columns.
I haven't been able to find any documentation on the language of cell referencing.