Skip to main content
Question

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

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!


    This topic has been closed for replies.

    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)]
    Terms & ConditionsAccessibility statement