Solved: Show If based on a field in a different table - Page 2

jfong12 · 05-22-2023 02:41 PM

Hi All,

I know that it is possible to reference another table/row but I am not sure if it is capable of being used as strictly show or not show an entry. I have two tables: Data and Error Log, Data is the main table that holds the majority of my App Sheet data, while Error Log only shows when an error occurs. Within both of these tables, they have a field of the same name, Applicant ID.

I am trying to accomplish, is when an Applicant ID matches in both tables I want the entry in the Error Log view to be hidden/not show. So far I have changed the column type for the Applicant ID to ref in the Error Log table and tried to dereference but I am not trying to result back.

Please let me know if this makes sense!

dbaum

@jfong12 wrote:

I want the entry in the Error Log view to be hidden/not show

It sounds like you're using (or need) a slice. The slice's row filter condition should include:

NOT(IN([Applicant ID], Data[Applicant ID]))

View solution in original post