
I have three fields:
Auto M - this is a multiple select picklist field
TType - this is a picklist field
Delivery - this is a picklist field
I need to validate that If Auto M field equals "between" AND ttype field equals "Auto" then Delivery field is mandatory.
Any suggestions greatfully received ;o)
6 Antworten
AND(
INCLUDES(Auto M, "between"),
TEXT(TType) = "Auto",
ISBLANK(TEXT(Delivery))
)
Try that (insert your API Field Names using the Insert Field Button in the Formula Editor)