FavoriteRenai McCullagh (ADA Australia) asked in #CollaborationApr 29, 2021, 7:54 AMValidation RuleI need to write a Validation Rule where a particular Contact Record Type selects a status of closed it can't close until 2 picklist fields have selections in them1 answerSortSort by DateSort by Most HelpfulSort by DateEric Praud (Activ8 Solar Energies)Apr 29, 2021, 8:02 AMHI Renai, Try this:AND(RecordType.Name="Name of the record type here",TEXT(Status__c)="Closed",OR(NOT(ISBLANK(TEXT(Picklist1__c))),NOT(ISBLANK(TEXT(Picklist2__c)))))Show MoreAdd a commentWrite an answer...BoldItalicUnderlineStrikethroughBulleted ListNumbered ListAdd linkCode blockInsert imageAttach filesLink URLCancelSave0/9000Reply
Eric Praud (Activ8 Solar Energies)Apr 29, 2021, 8:02 AMHI Renai, Try this:AND(RecordType.Name="Name of the record type here",TEXT(Status__c)="Closed",OR(NOT(ISBLANK(TEXT(Picklist1__c))),NOT(ISBLANK(TEXT(Picklist2__c)))))Show More