I'm wondering if there is a way to use a custom formula in existing columns? Especially for Sold Items List Item Purchase Price. I know there is logic to pull that from Item Master sheet, but is there a way I can put in my own formula that will always be used instead of the included one? I know that I can overwrite a cell with any data or formula, but how can I make that formula STICK in a column?
