Possibility of allowing table formula to reference cells in a different table (at least on the same page)? #1023
Description
Problem to Solve
I am using multiple tables on a single page to create a layout interspersed with text, images, etc. Many of my tables reference or use a value from one of the other tables as a source for their values (for example, a table containing scores for character attributes such as strength, dexterity, etc. and a later table listing attacks that needs that strength score and adds it's own bonus from the attacks table for a specific weapon). If any of these base values change, every single other table then needs to be manually updated with the new value. Tables must remain separate for layout and versatility, because otherwise I may as well be using an excel sheet and not OneNote, haha :p
New Feature/Solution
Add some way to reference at least 1 cell from a different table when calculating a formula (similar to Excel's Table_Name[Column_Name] structured references for tables or [Workbook_Name]Sheet_Name!Cell_Address reference format in formulas). Each table could be given a unique identifier (or perhaps already is) based on when it was created or when the function is run (I'm okay with tables changing their identifiers if they get rearranged on the page or something).
Alternative Solutions
An alternative solution is some way to specify a variable that is persistent across tables and able to be used in formulas, allowing 1 change to the variable to then let all tables/formulas be recalculated with the new value.
Additional Context
Let me know if you can immediately think of any workaround that already exists or a way to implement this simply using the plugin functionality that already exists - I am proficient in coding but not in the languages used by OneNote/OneMore. I'm not opposed to doing some work myself if it means the difference between having functionality vs. not! :)