Anyone know why this is returning "Corporate" only?
if(CONTAINS("@gmail:@yahoo:@aol:@hotmail:@msn:@wanadoo:@comcast:@live:@outlook", Email ),"Personal","Corporate")
답변 2개
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")