I get this error:
The formula expression is invalid: Syntax error. Missing ')'
Also not positive I have everything else right. What I want this to say is the Affiliation Status picklist should be new and not blank OR changed and not blank, AND it should be an affiliation between two kinds of Record Types AND the Role picklist value should be Teaching Artist.
AND
( OR
(
AND(ISNEW(),NOT(ISBLANK(TEXT[hed__Affiliation__c].hed__Status__c ))),
AND(ISCHANGED(TEXT[hed__Affiliation__c].hed__Status__c ),
NOT(ISBLANK(TEXT[hed__Affiliation__c].hed__Status__c )))
),
([hed__Affiliation__c].hed__Contact__r.RecordType.DeveloperName = "Teacher"),
([hed__Affiliation__c].hed__Account__r.RecordType.DeveloperName = "Program"),
(ISPICKVAL[hed__Affiliation__c].hed__Role__c, "Teaching Artist")
))