IF Function that produce multiple "value_if_true" outcomes

Paul Newcome

The reason your formula is returning blank if there are multiple trues is because you have the formula as a nested IF which works from left to right and stops on the first true value. To be able to populate multiple outputs based on multiple true values, you would have to "add" your IF statements together instead of nesting them.

=IF(Column@row = "A", "A") + IF(Column@row = "B", "B") + ...............

Having said that, there is unfortunately no way to use a formula to output multiple useable contacts into a single contact cell even if the columns set to allow multiple contacts.