Any help with below rule would be appreciated.
When Record is Not New and Field A, B, C are Blank. Then to require these fields.
also, excludes Profiles 1, 2 and 3.
AND(
NOT(ISNEW()),
OR(
ISBLANK(TEXT(Field A)), <---- (Picklist)
NOT(INCLUDES(Field B, "")), < ---- ( Multipicklist)
ISBLANK(TEXT(Field C)) <----- (Picklist)
),
NOT(CONTAINS("Profile 1,Profile 2,Profile 3", $Profile.Name))
)
Please help, currently while there are no syntax errors. I am able to save on record with no error.
Hello Everyone, advising that the following validation worked for me.
AND(
NOT(ISNEW()),
OR(
ISBLANK(TEXT(Field A)),
ISBLANK(Field B), <------- (multipicklist)
ISBLANK(TEXT(Field C))
),
NOT(
OR(
$Profile.Name = "Profile 1",
$Profile.Name = "Profile 2",
$Profile.Name = "Profile 3"
)
)
)
