You need to sign in to do that
Don't have an account?
Synthia B.
Validation Rule: Picklist Field and Date Field
After Lead Consultant is chosen from the picklist, the task can not be saved without a Completed Date. I am getting
Error: Field Final_Review_Lead_Consultant__c is a picklist field. Picklist fields are only supported in certain functions.
What am I missing?
AND(
Completed_Date__c = TODAY(),
ISPICKVAL (Final_Review_Lead_Consultant__c=TRUE
))
Error: Field Final_Review_Lead_Consultant__c is a picklist field. Picklist fields are only supported in certain functions.
What am I missing?
AND(
Completed_Date__c = TODAY(),
ISPICKVAL (Final_Review_Lead_Consultant__c=TRUE
))
AND(
NOT(ISBLANK(TEXT(Final_Review_Lead_Consultant__c))),
ISBLANK(Completed_Date__c)
)
All Answers
I am getting Error: Incorrect parameter type for function 'ISPICKVAL()'. Expected Text Literal, received Boolean for
AND(
Completed_Date__c = TODAY(),
ISPICKVAL(Final_Review_Lead_Consultant__c, TRUE)
)
It should be either one of them, I don't remember exactly which one.
AND(
NOT(ISBLANK(TEXT(Final_Review_Lead_Consultant__c))),
ISBLANK(Completed_Date__c)
)