Quick Base Discussions

Expand all | Collapse all

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

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

    Posted 01-10-2019 20:44
    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!




  • 2.  RE: How to make a formula text field editable while using a if else or case formulas

    Posted 01-10-2019 20:47
    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)]