I'm trying to add a calculated field that will take the closed date of an opportunity, add the contract length (years), and provide a new date when the contract expires. No luck on formulas so far, any suggstions?
I'm trying to add a calculated field that will take the closed date of an opportunity, add the contract length (years), and provide a new date when the contract expires. No luck on formulas so far, any suggstions?
Hello Amanda,
If the contact duration is always in years you could try something like this:
addDays($date_closed,multiply($contract_duration_years_c,365))
This is close, but added 4 days when I need it to add 4 years.
Can you share the exact formula that you are using?
addDays($initial_award_date_c,add($initial_years_c,365))
addDays($initial_award_date_c,add($initial_years_c,365))
I believe you just need to change the add() to multiply(), something like this:
addDays($initial_award_date_c,multiply($initial_years_c,365))
Awesome, that worked thank you! My next question, can I use that field we just calculated to be in another formula?
Perfect, yes, you should be able to search for it in the field selector on the formula builder: