hello,
i have something where two table are interconnected in excel.
for eg. table 1 is about salary and table 2 is about expenses and somewhere in table2 i want to calculate something using values from table1 in formula like “=C9/‘Salary’!C2*‘Tax’!$B$29” .
Multiple table relation
Hey @edmrepost33
the formula plugin doesn’t support that yet but you can use getDataAtCell/ setDataAtCell methods. Here’s a demo https://jsfiddle.net/1dLzb7st/
I’ve packed the logic into an afterChange hook to get the SUM updated.
2 Likes