Skip to main content
Conor Flanagan (Tines) 님이 #Sales Cloud에 질문했습니다

Anyone know why this is returning "Corporate" only?

 

if(CONTAINS("@gmail:@yahoo:@aol:@hotmail:@msn:@wanadoo:@comcast:@live:@outlook", Email ),"Personal","Corporate")

답변 2개
  1. 2021년 11월 17일 오전 12:59

    Hi  Conor,

     

    Try this

     

    IF(CONTAINS("@gmail:@yahoo:@aol:@hotmail:@msn:@wanadoo:@comcast:@live:@outlook", SUBSTITUTE( SUBSTITUTE( email, left(email ,FIND('@', email )-1) , ""),".com","") ),"Personal","Corporate")