Calculating a value in table one from values in table 2

[Chris_Hamoen]

Hello fellow community members,

I have a sheet (Sheet1) which has multiple columns - say ConfigValue1, ConfigValue2. Then I have a column called Result that calculates a result using those values and values (Logic1, Logic2) from Sheet2.

In Sheet1:Result, I want Sheet1:ConfigValue1 x Sheet2:Logic1 + Sheet1.ConfigValue2 x Sheet2:Logic2.

Note that the logic could be a bit more complicated.

I could put the logic right into Sheet1, but the issue is that we want to have a separate interface for entering logic.

Thanks!

[nea_lpatil]

@Chris_Hamoen

In case you are not satisfied with current solutions and would like to build App exactly as per your requirements then let me know (my contact info in my profile).

Thanks,
Neal