Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Gareth BuckleyGareth Buckley 

Validation rule question

Hi, I am trying to create a validation rule which I need to flag up an error message when the following occurs:

If field 1 = "Qualified" and field 2 "isnull" 

It is probably very basi but can anyone please assist?  Im used to SQL and not quite got the syntax.

Cheers,

Gareth
Best Answer chosen by Gareth Buckley
ThousifAli99ThousifAli99
Try this
AND(  TEXT(Status) ='Qualified' , ISBLANK(  Service_required__c )

All Answers

ThousifAli99ThousifAli99
Hi,
Please try this

AND( field 1=='Qualified' , ISBLANK( field 2))

Cheers
Gareth BuckleyGareth Buckley
Thank you.  I have put this in:  AND(  Status ='Qualified' , ISBLANK(  Service_required__c ).  The field 'Status' is a picck list and when I check syntax it brings up the following error:

Error: Field Status is a picklist field. Picklist fields are only supported in certain functions.

Any further assistance would be appreciated.

Thanks,

Gareth
ThousifAli99ThousifAli99
Try this
AND(  TEXT(Status) ='Qualified' , ISBLANK(  Service_required__c )
This was selected as the best answer
Gareth BuckleyGareth Buckley
That worked a treat.  Thank you very much!