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:

="D1@Sketch1"/234

I get an Excel error indicating that it does not know what "D1@Sketch1" is.

Does anybody know how to do this?

Include that dimension in the design table and then refer to the cell value