Home Unlabelled Formula field to count any 2 fields have yes selected, then do something

Formula field to count any 2 fields have yes selected, then do something

dasfrogpractice 07:18

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"
)

Formula field to count any 2 fields have yes selected, then do something

Formula field to count any 2 fields have yes selected, then do something

Reviewed by dasfrogpractice on 07:18 Rating: 5

No comments:

Subscribe to: Post Comments ( Atom )