Does anyone know how to fix and what a red pound (#) error means when working with DCs?
I’m using the “Nearest” function.
It works in one component and doesn’t when pasted into another.
I’m changing a couple parameters in the second component (LenX to LenZ) and (“36,48” to “72,84”).
Here are the functions:
Copied function (works): =NEAREST(CURRENT(“LenX”),36,48)
Pasted function (does not work): =NEAREST(CURRENT(“LenZ”),72,84)
Error Pasted function: #=NEAREST(CURRENT(“LenZ”),72,84)
I get a red “#” at the beginning of the function and the component does not honor the function.
I appreciate any help. Searching this issue is eating my lunch. I will also attach a sketchup file with the issue.
Dynamic Component Question.skp (2.5 MB)