I’m trying to create an order form that calculates price (FORMULA column) by multiplying the SQ. FT. size of an item by the SQ. FT. PRICE of the material. The SQ. FT. column is a simple calculation done based on sizes input into the order form. The SQ. FT. PRICE column is a linked field value pulled in from a different table (based on the material part number). I keep getting #ERROR! on the calculation.
The Error appears to be stemming from using a linked field value.
Look at the second image below…when I change the formula to use a different value from the same table it calculates without an issue.
Is this an odd occurrence or are you not able to use linked fields in formulas?