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

  • 0
  • 1
  • Question
  • Updated 2 weeks 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

  • 768 Points 500 badge 2x thumb

Posted 2 weeks ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 57,468 Points 50k badge 2x thumb
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)]