4 ms·
Actually what might be better is "sheet functions". So like pages where you can define input and output cells. Then you top level sheet can invoke the "function
by daxfohl 6y ago
Actually what might be better is "sheet functions". So like pages where you can define input and output cells. Then you top level sheet can invoke the "function" as like "=myfunctionsheet{A1=5, A2=9}.N8". That way you get local scope, etc, and you can do more complex stuff because it's very visual instead of being a mathematical function.
- daxfohl 6y agoObviously this will be best when used with Name Manager (especially if names can be scoped to the sheet) to name the input and output cells, rather than indexing off the cell ids directly.