Validation Rule: 1 Picklist and 1 Currency Field

Criteria:
If currency field Contracted Sales Volume_c is blank, AND
picklist field Time Period_c = Initial, Renewal, Extension, or Open Ended – Terms
Require: Contracted Sales Volume_c

Formula:
ISBlank(Contracted_Sales_Volume__c)&& OR( ISPICKVAL( Time_Period__c , “Initial”) ,ISPICKVAL(Time_Period__c , “Renewal”),ISPICKVAL(Time_Period__c , “Extension”),ISPICKVAL(Time_Period__c , “Open Ended – Terms”))

Advertisements

Calculate Date: Ultimate Expiration Date minus Owner Expiration Notice

Requirement:
If Arrangement Type_c equals ‘Contract’
Calculate a Re-Bid Date_c which is the Ultimate Expiration Date_c minus Owner Expiration Notice.

Here’s the formula that worked:

IF( ISPICKVAL(Arrangement_Type__c, ‘Contract’) , Ultimate_Expiration_Date__c – CASE(OwnerExpirationNotice,”15 Days”, 15,
“30 Days”, 30,
“45 Days”, 45,
“60 Days”, 60,
“90 Days”, 90,
“120 Days”, 120,Null) , Null)

If you’d like to see how I ended up here and the conversation posted on Answers, visit http://bit.ly/1d2Eq5A

Much thanks to Jeff May, Damien Owen, and Andrew Johnson for taking the time and providing the guidance/solution.