function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
MikeyOMikeyO 

Making a field mandatory if a certain field is selected

I want to make some text fields mandatory if a certain value is selected from a picklist. How do I do that?
i.e. 
If
Picklist = Public Relations
Then make the following text fields mandatory:
  • Key Message?
  • Due Date?
  • Etc?
thank you-
Balaji BondarBalaji Bondar
Use below formula : 
AND(
ISPICKVAL(Picklist API Name , "Public Relations"),
	OR(
	ISBLANK(Key Message),
	ISBLANK(Due Date),
	ISBLANK(Etc)
	)
)
Important :
If this is what you were looking for then please mark it as a "SOLUTION" or You can Click on the "Like" Button if this was beneficial for you.
MikeyOMikeyO
Balaji,

OK here is what I have, but get this error: Error: Syntax error. Found ')'
  
AND(
ISPICKVAL(Type_of_Asset_Required__c , "Public Relations"),
    OR(
    ISBLANK(What_are_you_trying_to_accomplish__c),
    
    )
)

 
Balaji BondarBalaji Bondar
Try this, 
AND(
ISPICKVAL(Type_of_Asset_Required__c , "Public Relations"),
ISBLANK(What_are_you_trying_to_accomplish__c)
)