Is it possible to reference more than one sheet within a single Google Sheet file? For example, I have this Google Sheet set up with 3 named sheets:
The first sheet uses formulas to sort the data from the second sheet. So I want to be able to get/set the values on the second sheet while syncing the values on the first sheet with a Data Viewer List (DVL) in Thunkable. That way, I can update the second sheet and still display sorted values in Thunkable.
Is that possible? From the looks of it, there is not a way to select which sheet is connected to a DVL. In this screenshot, I selected a Google Sheet called Menu Survey but there’s no option to select a sheet within Menu Survey.
Is it just me or is it confusing to call something a “Google Sheet” and then have tabs called “sheets” within it?