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!
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!
