Hi

I am trying to get a field to become visable on the Quote Module only if the Customer Number selected is equal to a specific number such as 323001419.

The visability of the field is dependent on a formula. This is the formula i have tried is below

related($billing_accounts,"pr_account_number_c")isInList(323001419,createList(323001419,323001420)=true.

Its not working for me. Anyone have any ideas?

Hi Rosemarie,

When creating a dependent formula, the primary formula needs to be a boolean-type (i.e. returns true or false). You have the right elements in your example, but they need to be reorganized. The formula you should use is:

This means that the formula will compare the pr_account_number_c field against the defined list in your formula. If the value exists, true will be returned and the field will be displayed.

I hope this helps!