For example, We have a drop column where the choices are home, office, or either... we would like if they chose the either option that values from two columns show up. We currently have this formula which is working fine to return just ONE answer... we would like the last IF HAS function to return both personal and professional email. Is there a way to do that??
=IF(HAS([Please note your communication preferences]@row, "NO, REMOVE me from BOTH MAILING and EMAIL lists"), "", IF(HAS([Please note your communication preferences]@row, "Yes, please send MAIL ONLY"), "", IF(HAS([Please note your email and mailing preferences]@row, "Mail and/or Email to HOME only"), [Personal Email Address]@row, IF(HAS([Please note your email and mailing preferences]@row, "Mail and/or Email to OFFICE only"), [Professional email address]@row, IF(HAS([Please note your email and mailing preferences]@row, "Mail and/or Email to EITHER home or office"), [Personal Email Address]@row)))))
Where is would look kind of like this:
