Good morning,

I have a field (X) which is automatically updated every so often.  We track this data for various reasons and it's key, so I'd like to receive a notification in specific circumstances.

We have a Pick List field which is one of the conditions (if Pick List is A, B or C) but what I really need to set is if X changes from Blank or <=0 to >0, or from >0 to <=0.

As yet I'm unable to find a way to do this.  I did consider having a 'previous value' field (Y) but I can't find a way to automate adding the old value to there whenever X is updated.

Any suggestions on how to work around this?

Thank you,

Zayd