Author Topic: How to setup Custom Formulas in Existing Columns  (Read 126 times)

maw74656

  • Newbie
  • *
  • Posts: 1
    • View Profile
How to setup Custom Formulas in Existing Columns
« on: November 11, 2022, 01:58:25 pm »
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?

Scott

  • Administrator
  • Sr. Member
  • *****
  • Posts: 327
  • https://mycostpro.com
    • View Profile
    • MyCostPro
Re: How to setup Custom Formulas in Existing Columns
« Reply #1 on: November 14, 2022, 06:32:09 pm »
Hi,
Did you intend to set this formula up in the product master or in the sold item tab directly?