AnsweredAssumed Answered

Use a dimension value in a formula in a design table

Question asked by Eric Snyder on Jan 21, 2015
Latest reply on Jan 21, 2015 by Jamil Snead

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?

Outcomes