How do I write a formula using two picklist values to equal an amount?
Here is what I want to do... If the picklist (product_category__c, "Hardware") AND if the picklist (product_sub_category__c, "Wired") then $500).
I will need to do this for several scenarios for the same field, meaning different combinations of category/subcategories. Also, Product Sub-Category picklist is dependent on what is selected in product category picklist. And finally, should I be using a formula field?