+ Start a Discussion
Leonard Silon 16Leonard Silon 16 

how do I get contact phone number on a case

On a task I have a custom field named Test that is a checkbox and a formula.
The formula I want is 
IF( Related_Case__r.Contact.Phone =  Phone_Number_in_Subject__c , TRUE, FALSE)

If the related to is a case (ID starts with 500) and the case has a contact on it, then I want to check if the contact phone and the phone number of the customer that called in are the same. If so, then check the box. 

The phone number from subject is 10 digits with no () or dashes. The phone number on the contact has () and dashes. 

How do I get the contacts phone on the task
NagendraNagendra (Salesforce Developers) 
Hi Leonard,

There's a solution already posted to the above question on the success community.

Please refer to below link with a similar discussion. Kindly mark this as solved if it's resolved.