You need to sign in to do that
Don't have an account?
sftechlearner
Date when first opportunity is changed to closed won?
Hi ,
We would like to create a date field(formula field or a roll up summary field) in the Account level that captures date when the first opportunity associated to the account goes to closed won.
Is there a workaround to do this?
Thank you!!
We would like to create a date field(formula field or a roll up summary field) in the Account level that captures date when the first opportunity associated to the account goes to closed won.
Is there a workaround to do this?
Thank you!!
1. Create a Roll Up Summary field on Account to count the number of related opportunities - Number_Of_Opp__c
2. Create a text field on Account called First_Opp_Id__c - this will store the Id of the first opportunity that is created
3. Create a date field on Account called - First_Date_Of_First_Opp_Closure__c - this will store the actual date
4. Create a field on Opportunity - Ensure_Single_Execution__c(a checkbox field)
5. Create a WF rule on Opp - this will store the Id of the first opp in a field on the account object
Evaluation - When a record is created and edited
Filter - AND(
ISNEW(),
Account.Number_Of_Opp__c = 0,
Account.First_Opp_Id__c = null
)
6. Create a Field Update on Opportunity and set the value in the Account.First_Opp_Id__c field - with Opportunity Id - associate it with the WF created above
7. Create another WF Rule on Opportunity
Evaluation - Created and every time the record is edited
Filter - AND(
Ensure_Single_Execution__c = false,
NOT(ISPICKVAL(PRIORVALUE(StageName),"Closed Won")),
ISPICKVAL(StageName, "Closed Won"),
Account.First_Opp_Id__c = Id
)
8. Create two field updates and add that to the WF rule created in the step above
a. Update the date field on Account with today's date
b. set the checkbox to Ensure_Single_Execution__c to true
Let me know if this works.
Thanks,
Kaustav