6 answers
Hi anji & Manish,Consider you want to update the stageName field as 'Closed won' and some fields like type, amount etc 'in a single update'. If you have not used 'NOT (ISCHANGED(StageName))' means, the above action won't be happened. Manish clearly told this in his requirement.Else, you can use 'ISPICKVAL(PRIORVALUE(StageName ), "Closed Won")'. Both are correct..Try this, you can understand clearly.Thanks,Vignesh P Hi manish, Edit your formula field like below. =====================================AND (ISPICKVAL (StageName, "Closed won"), NOT (ISCHANGED(StageName)), OR (ISCHANGED(Type), ISCHANGED (Amount), ISCHANGED (LeadSource), ISCHANGED (CloseDate)) )=========================================If there are any issues, Let me know.Thanks,Vignesh P Hi,Pls try this..AND( (ISPICKVAL(PRIORVALUE(StageName ), "Closed Won")),OR(ISCHANGED( Type ), ISCHANGED( StageName ), ISCHANGED( Amount ), ISCHANGED( LeadSource ), ISCHANGED( CloseDate )) )Thanks Hi Vignesh,May i know why you have used NOT (ISCHANGED(StageName)), Thanks and RegardsAnji Thanks Vignesh! your formula is working. :) You should check PREVIUS VALUE for Stage field along with the existing formula.Thanks.