I need to use the value from a dimension to feed some complex formulas in a design table. The result of the complex formula will set a custom property value.
How can I use the value of the dimension in a formula in a cell in the spreadsheet?
D1@Sketch1 = 5
In cell R5C20 the formula:
I get an Excel error indicating that it does not know what "D1@Sketch1" is.
Does anybody know how to do this?