Help

Re: Multiple Columns (3) Nested IF

Solved
Jump to Solution
534 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Gio
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi All,

I am trying to go around this nested formula and hope someone could help me try understand why is not working.

I have three {columns} that indicate if a condition is either 1 or 0.

So:
column 1 can be 1 or 0
column 2 can be 1 or 0
column 3 can be 1or 0

I have a fourth formula column where I want to indicate the following:

IF column 1,2,3 are all 1 then show “status A”
IF column 1,2 are 1 and 3 is 0, then show “status B”,
IF column 1,2,3, are 0, then show " status C"

I have tried this formula but it wont go through:

IF(
OR(
FIND(“1”, {column1}
),
FIND(“1”, {column2}
),
FIND(“1”, {column3}
),
),
“status A”,
IF(
OR(
FIND(“1”, {column1}
),
FIND(“1”, {column2}
),
FIND(“0”, {column3}
),
),
“Status B”,
IF(
OR(
FIND(“0”, {column1}
),
FIND(“0”, {column2}
),
FIND(“0”, {column3}
),
),
“Status C”,
)

Thanks for whoever takes time to help out with this.

1 Solution

Accepted Solutions
Gio
5 - Automation Enthusiast
5 - Automation Enthusiast

I thing I have solved it :laughing:

IF(A2=0,”STATUS B”,IF(AND(A2=0,A3=0),”STATUS A”,STATUS C”))

Sometimes you pursue a direction to find a solution and miss the easier way!

Leave here for reference :slightly_smiling_face:

Really great community btw.

See Solution in Thread

3 Replies 3
Gio
5 - Automation Enthusiast
5 - Automation Enthusiast

I thing I have solved it :laughing:

IF(A2=0,”STATUS B”,IF(AND(A2=0,A3=0),”STATUS A”,STATUS C”))

Sometimes you pursue a direction to find a solution and miss the easier way!

Leave here for reference :slightly_smiling_face:

Really great community btw.

Welcome to the community, Gio! :grinning_face_with_big_eyes: Nice work on the solution! I’m a little confused why your field names don’t appear to match with the criteria you listed in your first post, but hey, you know your fields. :winking_face:

Just to toss this out there, this could also be done with the SWITCH function. It wouldn’t be any shorter, but maybe a hair more clear. Going from your initial criteria:

…and naming the fields {C1}, {C2}, and {C3}, it would look like this:

SWITCH(C1 & C2 & C3, "111", "Status A", "110", "Status B", "000", "Status C")

Thanks Justin, that is very helpful.

Hope to contribute more to this awesome community.