+ Start a Discussion
SujanSaiSujanSai 

Missing data!

Hi,

I am working on the Lead object. I want to create a validation for not allowing the record to be saved when LeadSource is not entered.
Please suggest.
Thanks,
Sujan
Best Answer chosen by SujanSai
jyothsna reddy 5jyothsna reddy 5
Hi Sujan,
Please try this  below formula
 
AND(IsConverted, ISBLANK(TEXT(LeadSource))

I hope it will help you.

Regards,
Jyothsna D

All Answers

jyothsna reddy 5jyothsna reddy 5
Hi Sujan,
Please try this  below formula
 
AND(IsConverted, ISBLANK(TEXT(LeadSource))

I hope it will help you.

Regards,
Jyothsna D
This was selected as the best answer
Tarun Khatri (TK)Tarun Khatri (TK)
Helo Sujan,

If you want to restrict users from UI, you can mark that field as required from Page Layout. (Go to Steup > Lead > Page Layout > Edit).
User-added image

If you want to resctrict users through valiadtion rule, use below code in validation rule (Steup > Lead > Validation Rule > New).
 
ISBLANK(TEXT(LeadSource))

-Thanks,
TK

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.