• mbruso3
  • NEWBIE
  • 0 Points
  • Member since 2007

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 3
    Questions
  • 0
    Replies
None of the below Validation Rules return an error when the user forgets to enter a Phone Number.
Option 1
AND(
$Profile.Name = "System Administrator",
Phone=""
)
Option 2
AND(
    $Profile.ID  = "00e20000000hGsFAAU",
  Phone=""
)
Option 3
AND(
    $User.ProfileID  = "00e20000000hGsFAAU",
  Phone=""
)
How do we determine if a Picklist has any value selected.  Doesn't matter which value, just as long as one is selected.  This will be used as part of a Validation Rule.
So I just read that multi-picklists can not be used in formulas.  Would anyone have a solution or work around to determine if no values are selected on a multi-picklist?