Equations in BOM

Hi, I have an assembly which is driven by an excel spreadsheet and some of the components can become bespoke. In the BOM i have added a column and in the cell that coincides with the part I have added an equation which tells me if it is bespoke or standard. This works fine until I go to the assembly and alter it, on return to the BOM the equation in the cell has gone walkabout Any ideas.

SolidworksBill Of Materials