Making multiple column values NULL based on certain conditions

Question

I wanted to make Right_Name and Right_Email (these are just two columns but in my actual data there are more than 20 columns) NULL if the Name and Email are the same. How could I do that in one fell swoop instead of having a formula for every column?

Thanks,

A

aliensurfer · Accepted Answer

Thanks, @SPetrie . I used a multi-field formula for this. Basically if Name and Right_Name are the same AND Email and Right_Email are the same, I needed to make all the Right_XXX columns as blank.