function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
phillipsg208phillipsg208 

Comparing the prior value of a picklist to its current value.

I want to create a workflow field update formula that will take the prior value of a picklist and compare it to it's current value if someone changes it on the opportunity.  If the current value was "A" for example and was changed to "B", then I want a separate field to get populated with $User.Username to show who changed it.

I've tried playing with a combination of the ISPICKVAL and PRIORVALUE functions, but I can't seem to get the syntax right.

Any help steering me in the right direction would be much appreciated.

Thanks
Greg
smoodysmoody
Why not use history tracking for that field? Much easier and you can track every change instead of just the last change.
phillipsgphillipsg
I thought about that at first, but then realized that field tracking history isn't available on the opportunity.
smoodysmoody
That's the first time I ever looked at that. It really doesn't have history tracking. That's pretty strange.
phillipsg208phillipsg208
You'd think that would be the one place where you'd really want that feature too.  Thanks for replying though.  I appreciate it.
dbeaudoindbeaudoin
Did you ever find a solution for this?