Conditionally Showing/Hiding Data based on filter

[alwayslearning]

Hi,

I have created a customised 'Listbox' using :

=If(Match($Field, 'Department', 'Finance', 'Stage', 'Project Manager', 'Resource' , 'Date', 'On track' ), $Field)

I have created fields to identify the null values and  titled them Null Department, Null Finance etc  I am using these on other pages too and not all of them are simple Null values, some like the date have further criteria like <> current date etc.

1. I want to create a table which once I click on the field, the null value field appear.

2. I want a column on the table to show which field is being shown, so I can identify the null field which I have selected.

Find attached file as an example with my incomplete table

[settu_periasamy]

Maybe like attached

[alwayslearning · Accepted solution]

Thanks Settu for that,

I have actually been able to resolve another way, using conditional expressions to show and hide the data I need.

SubstringCount(  concat( distinct '|'  &  $Field & '|' ,'Department') , '|Project Manager|') >0

and realised displaying all the null data points in one column which was an aim, is probably not the best way to handle the data.