I need to create a formula for my industry pick list that will allow me to add a text box when 'other' is chosen as an industry.. We are a small business new to Salesforce and are unfamiliar with formulas
Hi @Micky Caswell When you say formula, I am guessing you need a Validation rule that will prompt users to enter a value into the text box when other is selected in the Industry picklist.
Create a Validation rule on the Object
Formula
AND(
TEXT(Industry) = 'other',
ISBLANK(Text_Field__c)
)
Click on the insert field button and select the text field that will get you the field API Names
Also, make sure the text with in the single quotes should match exactly how its saved in the system, for e.g. if the other is saved as Other in the industry picklist then you will need to use TEXT(Industry) = 'Other'
