How to make a formula text field editable while using a if else or case formulas

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • In Progress
I have a formula text field that is using either if or case statement to populate a value based on the choice from another field. For example, There is multiple choice field called [pricing Promo type]

And on the [New Exact Cost] field, which is a numeric formula field, I use the following formula

If([HD - Pricing Promo Type]="Regular Pricing", [HD Item - Master Item - HD - Cost], [HD - Pricing Promo Type]="Promo Pricing", [HD Item - Master Item - HD - Promo Cost], [HD - Pricing Promo Type]="Special Pricing", [HD Item - Master Item - HD - Special Deal Cost])

The above formula works perfectly fine. However, if I choose Custom option, I want to make the [New Exact Cost] field editable. How can I do this?

Thank you!

Photo of Sales Info

Sales Info

  • 818 Points 500 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
no can do.
But you can open up a new field to display called [Exact Cost Override] and then have a final formula field to calculate the [Exact Cost (final)]