Hi,
As in the topic above.
I want to add a new custom field which will be calculating a date. This field will be an opportunity product field. In this formula I want to add 2 values:
1) ServiceDate (date field in Opportunity product)
2) Duration_days__c (field type: number, it is a Product field).
Unfortunately, I cannot find Duration_days__c field in "Insert field" while using Advanced Formulas. This field is created, and its name is 100% correct.
I went through materials about formulas and still cannot find a solution.
9 réponses
Hi Michal, The formula will be as below
ServiceDate__c + PricebookEntry.Product2.Duration_days__c
Please click on Insert field button and the navigation path to product object will be as below
Opportunity Product > Price Book Entry > Product > select Duration days field
Also, use the insert field button to selec the Serivce Date field to get the actaul field API Name
