Phil’s Salesforce Tip of the week – 19th October 2012
There are a whole lot of formula options that you can use in Salesforce, in Validations, Workflows, formula fields, etc. Here’s another useful example:
Use the ISCHANGED formula to trigger when users have clicked the Edit button and are in the process of changing a record. So the example below says…when you are changing Status, AND the Record Type is … and the picklist value of the ‘Favourite Football Team’ Field is NOT ‘Manchester United’, then the error message will occur.
NOT(ISPICKVAL (Favourite_Football_Team_c , “Manchester_United”))
Error Message “You are clearly supporting the wrong team! ” 🙂
Here’s some other useful links about Formulas in Salesforce: