I'm trying to update static values of fields based on selections made by the user. I want to do this to minimize the number of fields required and to populate Salesforce correctly.
I have an Industry field that is set as a variable (Industry). It has a value of Media which has a variable value of 5. I want to make another field equal to "Media/Communications", if Industry = 5.
I was looking at this post and trying variations of the formulas here, but I'm still getting an error. http://www3.formassembly.com/forum/discussion/431/formula-within-calculated-field/#Item_0
This is what I currently has as my formula: If(Industry==5){'Media'}else{""}