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
PT_TangaTech01PT_TangaTech01 

Picklist and Date field Dependent Validation

Can someone please help with validation?  Comparing 2 fields on a custom object.
  • Field_A is a picklist
  • Field_B is a date field.

When saving, Field_B can't be empty when Field A has a selected value.

Seems straightforward but I can't figure out the syntax. Been scratching my head on this one. Thanks!!
Best Answer chosen by PT_TangaTech01
Ramu_SFDCRamu_SFDC
AND(NOT(ISPICKVAL( Field_A,"")),ISBLANK(Field_B))

Please mark this as the best answer if it resolved your issue.

All Answers

kevin lamkevin lam
Try this:
AND(NOT(ISBLANK(TEXT(Field_A))),
    ISBLANK(Field_B)
   )
Ramu_SFDCRamu_SFDC
AND(NOT(ISPICKVAL( Field_A,"")),ISBLANK(Field_B))

Please mark this as the best answer if it resolved your issue.
This was selected as the best answer
PT_TangaTech01PT_TangaTech01
Worked great! Thank you!