Skip to main content
Julia Basin (Pypestream) 님이 #Collaboration에 질문했습니다
Hi,

 

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

 

Thanks,

 

Julia
답변 5개
  1. 2018년 7월 2일 오후 5: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.