Multiple show/hide based AND and OR conditions, Can someone explain how to?

First, I am going to say: Vote for This Feature!!

Then you need to understand the current way an If-Then-Else (ITE) column works is by selectively eliminating possibilities one by one.

You may need multiple ITE columns to whittle down your possibilities.

For example, one ITE column to evaluate answer 2 and put the results into a “bucket”

If answer 2 is >= 140 then “Y”
if answer 2 is <= 50 then “R”
if answer 2 is > 99 then “A”
if answer 2 is < 60 then “A”
else
“X”

Then pare down answer 1 in the same way.
If answer 1 is > 100 then “R”
If answer 1 is <= 79 then “R”
If answer 1 is <=90 then “Y” (by now we know it is also 80 or greater)
if answer 1 is >= 92 then “3”
if answer 1 is >= 90 then “4”
else

My point is (and I probably messed up somewhere), but you do have conditions for <=90 on question 1 in one spot and >= 90 in another spot, so you need to resolve that conflict.

Then you’ll have a third ITE column to further whittle things down, remembering that once a branch is taken no other branch is looked at.

2 Likes