Skip to main content
Topics#Sales And MarketingWolfgang Red's Question
Wolfgang Red asked in #Sales And Marketing
Aug 8, 2017, 9:33 AM

Hi Guys, have you an idea to create a formula, which say:

if the end date of my "parent contract" younger as the end date from the "child contract", then show me in my new form field "SOS". thank you! i'm beginner
1 answer
  1. Nitish Singhal (Fonterra)
    Aug 8, 2017, 11:08 AM
    Tom,

     

    what do you mean by form? Do you mean page layout? 

     

    If yes, then your formula could be:

     

    Formula field: Return type: Text

     

    Formula: 

     

    IF(end_date__c < Parent_Contract__r.end_date__c, 'SOS','')

     

    please try. 

     

    Thanks
Write an answer...
0/9000