What happened to my formula?!?

[This post was originally published (by me) on the SharePoint365 blog (http://sp365.co.uk)%5D This issue arose several times in my company, so I imagine others have also run into it… [Note: this article applies to both MOSS and SharePoint 2010] Here’s the (simplified) scenario: I have a custom list called Jobs, containing basic information about the…