Skip to main content
I currenlty have 2 picklist that I need to generate price.

 

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 answers
  1. Mar 17, 2020, 1:50 PM
    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)