Allow referencing variables from other sheets
planned
Mike Schinkel
This is similar to allowing global variables to be defined in a sheet, but is not actually the same thing.
Basically I am asking for access to variables in other sheets like you can do in a spreadsheet like Excel or Google Sheets. This would mean a sheet would need a name, likely the heading but it would be good if a user could optionally give is a more concise name, maybe like the first image.
Then in another sheet be able to reference those variables with a qualified reference something like in the second image.
Zac @ Soulver
Merged in a post:
Set global variables within sheets themselves
It would be excellent if I could set a global variable in a sheet, rather than only in the application settings. e.g. "Expenses" is a list of all my monthly costs, which are summed into a global variable, which I can then refrence via my "Income" sheet. Thus adding or removing expenses automatically updates my Income sheet.
M
Mark Aronszajn
Any word on when you'll have this feature released? I await each new Soulver version with eagerness because I know it's planned :)
Zac @ Soulver
Mark Aronszajn: It's part of a larger feature that's still in development. The iPad app is currently my #1 priority, after that I'll be back on this.
M
Mark Aronszajn
Zac @ Soulver: Thumbs up! Soulver rocks...
Zac @ Soulver
planned
M
Mark Aronszajn
Zac @ Soulver: Great!
M
Mark Aronszajn
Or a different approach for the same benefit would be to allow imports of properties by referencing source sheets ('#<sourceSheetName>') at the top of the working sheet, as in bash/z-shell property files.
M
Mark Aronszajn
Yes, please, or in the manner of interpolated variables in Apache Configuration .property files. Source a specified sheet at the start, and then reference values of any variables defined in that specified sheet using '${VAR_NAME}'