2 Replies Latest reply on Jan 21, 2015 11:57 AM by Jamil Snead

    Use a dimension value in a formula in a design table

    Eric Snyder

      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?