I am trying to do the following: 
On a contact record, if the Mobile Phone field is not blank, use it to populate the Phone in Use field on the same contact record. If the Mobile Phone field is blank, then use the Work Phone field to populate the Phone in Use field. If the Work Phone field is blank, then use the Home Phone field to populate the Phone in Use field. If the Home Phone field is blank, then use Other Phone field to populate the Phone in Use field. If the Other Phone field is blank, the Phone in use field remains blank. 

I created the formula below, but I am getting an error I don't know how to fix: "Error: Incorrect parameter type for function 'IF()'. Expected Boolean, received Text"

IF(NOT(ISBLANK(MobilePhone)), Phone_In_Use__c = MobilePhone,
IF (NOT(ISBLANK(npe01__WorkPhone__c)), Phone_In_Use__c =  npe01__WorkPhone__c,
IF (NOT(ISBLANK(HomePhone)), Phone_In_Use__c =  HomePhone,
IF (NOT(ISBLANK(OtherPhone)), Phone_In_Use__c =  OtherPhone,
" "
))))
 

I have a formula field name Partner_involved__c on opportunity object, it should be marked 'true' when amount field in opportunity object is not blank, so i have written a formula-

IF(ISBLANK(Amount),"True","False")

but here irrespective of the amount field whether it is blank or not ,
The Formula field named Partner_involved__c is marking as 'False'.


Can anyone please explain how i can overcome this.

 I need to create a validation rule where a custom field end date /time is greater than 6pm then it should throw error
 End date field is custom and calculated upon saving of two field (start date/time + span hours)

Below is the rule created but not working as expected
AND(
    ISNEW(),
    ISPICKVAL(OCE__SpanType__c, "Hours"),
    IF(
        OCE__EndDate__c > DATETIMEVALUE(TODAY()+(21/24)),
        TRUE, FALSE
    )
)

Hello everyone,

 

 

Can anyone help me with the following issue(a simple one but I am unable to solve it)

 

I have two record types A, B of which B is set as default. 'B' has 5 profiles associated with it. Now, I want to delete the record type 'B' but unable to do so.  

 

Tried doing the following things but was unsuccessful:

1. Deactivate record type 'B'

2. Create new record type 'C' which has existing record type as 'B' and making it default.

 

When I try to delete 'B', there is an error message saying 'This record type cannot be deleted because the following profiles use this record type as default.' 

 

Any help in this is much appreciated...

 

Thanks in advance.