the Question Is  regarding Leave  Record ,  to calculate no of days based on start date  and End Date  and Also There is one Picklist field as a Leave Type and the picklist Values are 1) First half  2)  Second Half and 3) Full day 
 if user Select The First half With start date  and Date As same Then in no of days it should populate  0.5(no_of_Days__c is a formula Field)

 This formula Working fine for without picklist values we need to only do for FIRST HALF and SECOND HALF  Picklist Values .
  IF(End_Date__c == Start_Date__c, 1, (End_Date__c - Start_Date__c )+ 1)


 

Hi all, longtime lurker, first time inquirer.

I'm trying to build a summary field that assigns point values to different picklist fields based on the picklist field values (I've confirmed they're all picklists). I'm getting an error that states that the picklists are text, which they're not. Some cursory Googling leads me to believe there's a workaround and this is a bug, but haven't been able to get it to work.

The formula in question is below. Thanks for any help you can provide!
 

IF(ISPICKVAL(Alarm_Maturity__c, "1"), 1, 0) +
IF(ISPICKVAL(Alarm_Maturity__c, "2"), 3, 0) + 
IF(ISPICKVAL(Alarm_Maturity__c, "3"), 6, 0) +
IF(ISPICKVAL(Alarm_Maturity__c, "No"), 16, 0) +
IF(ISPICKVAL(People_Maturity__c, "1"), 3, 0) +
IF(ISPICKVAL(People_Maturity__c, "1"), 3, 0) +
IF(ISPICKVAL(People_Maturity__c, "2"), 9, 0) +
IF(ISPICKVAL(People_Maturity__c, "3"), 18, 0) +
IF(ISPICKVAL(People_Maturity__c, "No"), 48, 0) +
IF(ISPICKVAL(Process_Maturity__c, "1"), 3, 0) +
IF(ISPICKVAL(Process_Maturity__c, "2"), 9, 0) +
IF(ISPICKVAL(Process_Maturity__c, "3"), 18, 0) +
IF(ISPICKVAL(Process_Maturity__c, "No"), 48, 0) +
IF(ISPICKVAL(Leadership_Maturity__c, "1"), 2, 0) +
IF(ISPICKVAL(Leadership_Maturity__c, "2"), 6, 0) +
IF(ISPICKVAL(Leadership_Maturity__c, "3"), 12, 0) +
IF(ISPICKVAL(Leadership_Maturity__c, "No"), 32, 0)