I am trying to add another column to a lookup table using the same format that the lookup table already had for columns since they are all length values in inches such as FOD##length##inches, adding to the lookup table itself doesn't cause any issues that I am aware of, it is the editing of an existing lookup table formula in Revit for a dimension parameter that I want to pull values from a separate column. There are two parameters, Fitting Outside Diameter 1 & 2 both using the same column sizes but I want one to pull from a separate column. FOD1 is using size_lookup(Lookup Table Name, "FOD", 1.04 * Nominal Diameter 1 + 23/64", Nominal Diameter 1) & FOD2 is using size_lookup(Lookup Table Name, "FOD", 1.04 * Nominal Diameter 1 + 23/64", Nominal Diameter 2). The problem is that the values references the same column & I need it to be two separate columns since they reference two different nominal diameters...
Every time I try to edit the "FOD" part in the second formula for the new column I put into the lookup table FODb##length##inches Revit tells me that it is an invalid formula? If I edit the name of the column in the formula at all either adding or taking away from it revit gets upset & says it's invalid which is BS. So what am I doing wrong?