Filtering an imported list by user

Hello,

I have imported an excel spreadsheet, one of the columns contains the
customer (Agent).

I wish to filter the list so that users can only see the items which
are relevant to them.

The only way I can see to do this is to manually create a view which
filters by their name, but there are too many customers and different
views required to make this feasable.

I've tried filtering using the Me function, (which returns exactly the
same text as that which is in the Agent column), however, it is
searching for the text "=PROPER(RIGHT(Me,LEN(Me)-9))" rather than the
calculated value...

The user didn't create any of the items, so how can I filter it to
display only the relevant ones?

It's been driving me mad, thanks for any help.

spFan
Fri Jul 11 14:58:16 CDT 2008

hello,

Can you try with square brackets around Me like [Me], I am not sure
whether this will work.

But you can achieve this using the Current User Filter web part and
SharePoint List Filter web part available in SharePoint 2007. Using
Current User Filter web part you can get the logged-in user properties
and make use of it for filtering data in a list. The current user
filter web part will remain hidden at run-time. You can check out the
other ways of filtering a list in my blog http://sharepoint-world.blogspot.=
com

Regards
Ren


On Jul 11, 10:10=A0am, Dan <marnileon...@googlemail.com> wrote:
> Hello,
>
> I have imported an excel spreadsheet, one of the columns contains the
> customer (Agent).
>
> I wish to filter the list so that users can only see the items which
> are relevant to them.
>
> The only way I can see to do this is to manually create a view which
> filters by their name, but there are too many customers and different
> views required to make this feasable.
>
> I've tried filtering using the Me function, (which returns exactly the
> same text as that which is in the Agent column), however, it is
> searching for the text "=3DPROPER(RIGHT(Me,LEN(Me)-9))" rather than the
> calculated value...
>
> The user didn't create any of the items, so how can I filter it to
> display only the relevant ones?
>
> It's been driving me mad, thanks for any help.