Hi
I currently have the below but I also want to include NOT(ISPICKVAL( StageName , "Diverted") as well as in view however I cannot seem to get it to work.
Thanks in advance
Tina
AND(
NOT(ISPICKVAL( StageName , "In View")),
RecordType.DeveloperName = "New_Business_Real_Estate",
OR(
ISBLANK( This_Year_s_Terrorism_Line__c ),
ISBLANK( This_Year_s_RSA_POL_Line__c )
)
)
8 answers
Oops I did not read the whole question, here you go
AND(
NOT(ISPICKVAL( StageName , "In View")),
NOT(ISPICKVAL( StageName , "Diverted")),
RecordType.DeveloperName = "New_Business_Real_Estate",
OR(
ISBLANK( This_Year_s_Terrorism_Line__c ),
ISBLANK( This_Year_s_RSA_POL_Line__c )
)
)
