1

I have gone through a scenario. I need date/time of every stage change of an opportunity. I have created some date and time field to store opportunity stage change date. let says, if opportunity in stage 1 on 1st Jan so 1 date field updated by workflow the stage change date. Same I did with rest of stages and workflow criteria is "created and subsequently meet the criteria". but I saw every time I change the stage those fields got update. ideally fields should be update once. Like 1st jan for 1 stage then 2nd jan for 2 stage. if I again change the opportunity in 1 stage on 3rd jan so 3rd jan should not be store on 1 stage date/time custom field but actually it is updating. rule work like every time created and edited. I tired to set criteria formula evaluated but no luck. Any approach you can share. please help.

Improve this question
2
  • Got the answer. rule criteria would be formula evaluated like this "AND( ISPICKVAL( StageName , "Prospecting"), ISNull( Prospect_Date__c ))" so first time that custom field (Prospect_Date__c) will be null so workflow trigger and update the field in current date and time. and from next time it won't be match the criteria
    – Russel baker 1
    Jan 17, 2016 at 11:11
  • Have you looked at the opportunity stage history report? It's different from opp history as it just tracks date/time, stagename, and amount when stage is changed. Just throwing that out there.
    – gorav
    Jan 17, 2016 at 19:58

2 Answers 2

Reset to default
1

Got the answer. rule criteria would be formula evaluated like this 

AND( ISPICKVAL( StageName , "Prospecting"), ISNull( Prospect_Date__c ))

so first time that custom field (Prospect_Date__c) will be null so workflow trigger and update the field in current date and time. and from next time it won't be match the criteria.

Improve this answer
0

Have you think about audit that field? if you go to the opportunity fields you will see the field history tracking button on the top and you can activate it to the stage field of the opportunity.

Improve this answer
2
  • Earlier we use to do this but the problem with field history is when any update in amount or close date the time stamp shows on the field history. So I was getting too many date for same stage. So I have to do lot of work in Excel to get the exact stage change date. that's why I am thing to store each stage change date in custom date fields and report on them. but the problem which I am facing here is every time when I change stage from 2 to 1 or 4 to 3 date changed. I want once date store for first time on stage change it should lock. then from next time editing won't effect. @vanch
    – Russel baker 1
    Jan 17, 2016 at 10:54
  • Got the answer. rule criteria would be formula evaluated like this "AND( ISPICKVAL( StageName , "Prospecting"), ISNull( Prospect_Date__c ))" so first time that custom field (Prospect_Date__c) will be null so workflow trigger and update the field in current date and time. and from next time it won't be match the criteria.
    – Russel baker 1
    Jan 17, 2016 at 11:10

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .