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
Sienna Luard 3Sienna Luard 3 

I need a validation rule that makes an Event field mandatory for all profiles except partner community users

I need to make an Event field mandatory for all users who DO NOT have the Partner Community User.

I came up with this formula

AND(ISPICKVAL(ISNULL(Event__c ), 
$Profile.Name <> "Partner Community User"))

I get an error the following error.

Error: Field Event__c is a picklist field. Picklist fields are only supported in certain functions. Tell me more

Anuy ideas?
Best Answer chosen by Sienna Luard 3
Sienna Luard 3Sienna Luard 3
I figured it out!

AND(ISPICKVAL(PRIORVALUE( Event__c ), ""), 
$Profile.Name <> "Partner Community User")

All Answers

Sienna Luard 3Sienna Luard 3
I figured it out!

AND(ISPICKVAL(PRIORVALUE( Event__c ), ""), 
$Profile.Name <> "Partner Community User")
This was selected as the best answer
Mathew Hayden 6Mathew Hayden 6
Happy Valentines Day Quotes, Wishes, Messages For Him/Her (http://rightquotes4all.com/happy-valentines-day-quotes/)