LinkedIn
Twitter
1 ACCEPTED SOLUTION
Hello Steve
Iโve been working around and I seem to have made it work.
But, I donโt understand why this works.
First, I went to the Data pane - chose Columns.
Then, I have 13 name columns such as inch HG, ATM, PSI, and so on.
Then, I clicked on one of them and scrolled down to Auto Compute and chose Spreadsheet formula, where I typed =โMatrix Defaultโ!C2*Matrix!B2.
Then, I saved it and went back to it, and deleted it.
I repeated this for the remaining name columns.
Now, all the name columns appear on my app and are functioning as expected.
Do you know what this Spreadsheet formula actually does?
My Excel worksheet has many formulas on each cell.
Thank you.
