Sign Up ›

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

Simple validation syntax issue

Hi i'm trying to write this validation and seems i cannot get syntax properly:

If Email.Package or Fax.Package = today , Salutation cannot be blank

can someone please help me?

thx in advance :)

Best Answer chosen by cldave
CheyneCheyne
I believe you have to use ISPICKVAL() instead of ISBLANK().

AND(OR(Email.Package=TODAY(), Fax.Package=TODAY()),ISPICKVAL(Salutation, ""))

All Answers

CheyneCheyne
Try this

AND(OR(Email.Package=TODAY(), Fax.Package=TODAY()),ISBLANK(Salutation))
cldavecldave
Ty for your answer but issue i'm having is that Salutation is a picklist field and i get the following error:



 Field Salutation is a picklist field. Picklist fields are only supported in certain functions
CheyneCheyne
I believe you have to use ISPICKVAL() instead of ISBLANK().

AND(OR(Email.Package=TODAY(), Fax.Package=TODAY()),ISPICKVAL(Salutation, ""))
This was selected as the best answer
cldavecldave
Tyvm Cheyne, that worked :)