boolean on other boolean

Hi rafterse 

Thanks for the reply from sanalytics .

If your problem has not been resolved, try the following:

Create a calculated column as follow

Action =
IF (
    [Induction complete_] = "False",
    "Complete Induction",
    IF (
        [Test result_ ] = "Pass",
        "Test " & [Test name_] & " Pass",
        "Retake test " & [Test name_]
    )
)

Create a calculated table as follow

Table 2 = SELECTCOLUMNS('Table', "User_", [User_], "Action", [Action])

Result:

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.