SheetsIO icon indicating copy to clipboard operation
SheetsIO copied to clipboard

Published 20 hours ago • verified publisher icon GrandyB

Multi-sheet cell references

Open GrandyB opened this issue 4 years ago • 1 comments

Currently, "worksheetName" is part of config as a whole, not per cell. When we go to get the latest version of the data, we only ever look at that one sheet.

It would be nice to be able to define which sheet a cell belongs to, and query multiple sheets simultaneously, because for more stat-heavy productions, it's nicer to have things separated out into different sheets in the same workbook.

GrandyB avatar Aug 09 '20 00:08 GrandyB

I think #21 is more pressing than this. Multi-sheet has the added complication of using up more API calls (as calls are one per sheet); so you'd have to have the option to scale update time by # of sheets you're querying against.

Given that people could just have multiple app windows open I think #21 will do for now.

GrandyB avatar Feb 10 '21 20:02 GrandyB