Sign Up ›
  • phillipsg208
  • NEWBIE
  • 0 Points
  • Member since 2007
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
5 replies

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
5 replies

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