Need a formula to make Contract Date = (Close Date - 30 days), if Type = Renewal
Thanks,
Julia
5 answers
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 = DateIF(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.