Conditional drop WITH 2 criteria

[desmond_lee]

Hi There

Got stuck in Reference subtract. (PROJECT LIST[ PROJECT ID]-SELECT(Test Record[PROJECT ID],[ SITE NAME]=[_THISROW]).[ SITE NAME]).

In this expresion how do I put another condition on the PROJECT LIST table [REVIEW CONCLUSION]="APPROVED" ?

The expected drop down is that Question that already answer should not appear in the TEST RECORD table dropdown with the criteria column REVIEW CONCLUSION is approved.

[lynchk21 · Accepted solution]

If I understand correctly, I think you could:

1. Create a slice called APPROVED PROJECTS on the PROJECT LIST table with the expression [REVIEW CONCLUSION]="APPROVED"
2. Use the expression  APPROVED PROJECTS[ PROJECT ID]-SELECT(Test Record[PROJECT ID],[ SITE NAME]=[_THISROW]).[ SITE NAME]).

[desmond_lee]

Thnak so much. How come I di not think of thin of slice wich I di in other apps.