Advanced Show_If statements

[Daniel_4PS]

I am part of a team trying to build a form that uses conditional logic through Show_If statements to determine whether or not to present the column to the user based on values contained in columns on another table that correspond to a row that matches the value of the column.

We have a table with a list of all of our product features. We are trying to build a form to test each feature based on designated Test Groups and Test Status. How do you build a Show_If formula to present Table 1[Column X] on a form based on the value of Table 2[Parameter 1] = “Show_If Condition 1” and Table 2[Parameter 2] = “Show_If Condition 2” based on Table 2[Feature ID] = “Table 1[Column X]”

• LOOKUP Value of Test Questions All FIDs[Column Name] (ie “G-01: User Registration”) in features[Feature ID]
• MATCH Test Questions All FIDs[Test Group] User Response in the Form to the value of features[Test Group] in the row features[Feature ID] = “G-01: User Registration”
• PRESENT COLUMN on the form IF features[Test Status] = “Not Yet Tested” or “Retest Required” in the row features[Feature ID] = “G-01: User Registration” | * Alternative logic * could be PRESENT COLUMN on the form IF features[Test Status] <> “N/A” or “Passed” in the row features[Feature ID] = “G-01: User Registration”