Formula field to count any 2 fields have yes selected, then do something
IF( ( IF(ISPICKVAL(Field_1, "Yes"), 1, 0) + IF(ISPICKVAL(Field_2, "Yes"), 1, 0) + IF(ISPICKVAL(Field_3, "Yes"), 1, 0) ) >= 2, "Big", "Small" )
IF( OR( ISBLANK(TEXT(Field_1)), ISBLANK(TEXT(Field_2)) ), "", IF( AND( ISPICKVAL(Field_1, "Yes"), ISPICKVAL(Field_2, "Yes") ), "Big", "Small" ) )
IF( AND( ISPICKVAL(Field_1, "Yes"), ISPICKVAL(Field_2, "Yes"), CONTAINS(Field_3, "UK") ), "", IF( AND( CONTAINS(Field_3, "UK"), OR( ISBLANK(TEXT(Field_1)), ISBLANK(TEXT(Field_2)), ISPICKVAL(Field_1, "No"), ISPICKVAL(Field_2, "No") ) ), "No", "" ) )
Formula field to count any 2 fields have yes selected, then do something
Reviewed by dasfrogpractice
on
07:18
Rating:
No comments: