Picklist #1: Package
Picklist #2: Square Feet
For the square feet picklist. Options 100, 200, and 300 square feet should return a of $70 when Package #1 is selected. I can't seem to figure this one out. I have found many formulas online that involve 2 picklist. Is there anyone that help me figure this out?
9 respuestas
So basically something like this?
CASE( Package__c ,
'Package 1',
CASE( Square_Feet__c,
'100' ,70,
'200', 70,
'300', 70,
0 ),
'Package 2',
CASE( Square_Feet__c,
'100' ,90,
'200', 90,
'300', 90,
0 ),
NULL)