Hi All,

Intermediate user here. I have a custom object for Admissions Documents. Each applicant can be assigned a various number of Admission Documents. I need a formula that would look at all assigned Documents to see if they are all listed as picklist vaule "Complete". Here is what I have come up with, but it does not work.

ISPICKVAL(Admission_Document__r.Document_Status__c, "Complete")

Thanks in advance for any help.
Donna

Hi All,

Intermediate user here. I have a custom object for Admissions Documents. Each applicant can be assigned a various number of Admission Documents. I need a formula that would look at all assigned Documents to see if they are all listed as picklist vaule "Complete". Here is what I have come up with, but it does not work.

ISPICKVAL(Admission_Document__r.Document_Status__c, "Complete")

Thanks in advance for any help.
Donna