I need help on writing a formula as per the following criteria..
I want to track the count of changes/updates made on a date field called Customer Gained Date. When a record is created, the date is autopopulated so that counts as 1. if any update is made, it becomes 2 and so forth.
Is is possible without a trigger?
Thanks,
2 Antworten
Yes it is very much possible.
Create a number field called say, Customer Gained Count.
Then create a WF field update on this new field and try the syntax below..
IF(ISCHANGED(Customer_Gained_Date__c),Customer_Gained_Count__c+1,PRIORVALUE(Customer_Gained_Count __c))
The WF evaluation criteria should be created and everytime it is edited.
Hope this helps.
