Skip to main content
Hi,

 

Need a formula to make Contract Date = (Close Date - 30 days), if Type = Renewal

 

Thanks,

 

Julia
5 Antworten
  1. 2. Juli 2018, 17:17
    Since you're using Close Date, I'm guessing your Contract object is related to Opportunity...is that correct ?

     

    If yes, and if you are creating a custom formula field, it would look like this:

     

    Formula Return Type = Date

    IF(TEXT(Opportunity__r.Type) = "Renewal",

    Opportunity__r.CloseDate - 30,

    NULL

    )

     

    ...or if you are creating a workflow rule, your field update would utilize the above formula to update your date field.