Help

4 Column If / Then Formula Help Please

Topic Labels: Formulas
Solved
Jump to Solution
772 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Cole_Wedemeier
6 - Interface Innovator
6 - Interface Innovator

I have 3 columns that have data, and for any given record, only 1 of those columns will have data. I’d like a 4th column to populate the data that’s in whichever of the 3 columns has data.

Examples:
Column A = Blank, Column B = Blank, Column C = ABC, then Column D = ABC
Column A = XYZ, Column B = Blank, Column C = Blank, then Column D = XYZ
Column A = Blank, Column B = MNO, Column C = Blank, then Column D = MNO

I cannot for the life of me figure out an IF/AND or a nested IF statement(s) that will make this work.

Is this at all possible?

Here’s a snipit of my table where I’d like Interaction ID to handle what Column D in my previous explanation would have.
image

I appreciate any insight. Thank you!

1 Solution

Accepted Solutions
augmented
10 - Mercury
10 - Mercury

Hi Cole. I haven’t tried what I’m about to suggest, but I see no reason it shouldn’t work.

Let your formula be…

{[Pre-App] Interaction ID}&{[Partials] Interaction ID}&{[Apps] Interaction ID}

Let us know if that works.

See Solution in Thread

2 Replies 2
augmented
10 - Mercury
10 - Mercury

Hi Cole. I haven’t tried what I’m about to suggest, but I see no reason it shouldn’t work.

Let your formula be…

{[Pre-App] Interaction ID}&{[Partials] Interaction ID}&{[Apps] Interaction ID}

Let us know if that works.

Why is it sometimes we just feel we have to overcomplicate it? Oh man, this worked perfectly! Thank you so much, @augmented