Check current selections of a sheet before adding a filter to current sheet.

[ivandrago]

Hi,

I have the attached document.

What I want it to do is when the "Users" sheet is activated I want it to check the "Main" sheet and see if the selection Dept = "IT" is one the "Current Selections", if it is I want it to removed from the Current Selections on "Users" sheet and then make the selection Dept - "Finance".

Thanks

[MayilVahanan]

HI

Please check the attached file and let me know this you want??

Regards,

R.Mayil Vahanan

[ivandrago]

Nice work! Very clever!

[ivandrago]

Hi Mayil,

How do I make it select another field from another table?

So if Sales is Sleected, I want it to choose the City London when the "Users" Sheet is Activated.

Thanks

[MayilVahanan]

Hi

Hope you have link between two tables,

if so,

use like this

select in field: City

search string: =if(getfieldselecions(Sales)>0,'London','')

i didn't open the file.am in outside.. so oly.

[ivandrago · Accepted solution]

Thanks Mayil, the epression did not work but I changed it to the following

=if(GetCurrentSelections('Sales')>0,'London','')