Exclude rows from a slice using data in another table

AppSheet AppSheet Q&A
,
1

Hi,

I have a table called “Current Month” with Students names in a column called “Search term”.

My app adds the “Search Term” to another table called “Registered Students” when they arrive at class using the same column name.

Is there a way to create a slice that only shows those students in “Current Month” that are not in “Registered Students”?

Hope that makes sense!

Many thanks in advance,

Ian

2

Hello Ian, and welcome to the community!

I believe you should read this: List Subtraction.

1 Like