Sharepoint Filter

Question

Hi All,

I have two lists,

Status

1. Name (string)
2. Active (yes/no)

Task

1. Name (string)
2. Status (Lookup to Status list)

I have the following statuses (These can be changed at any time by the client):

• New, Active = Yes
• Open, Active = Yes
• Not Resolved, Active = No
• Resolved, Active = No

I want to create a view for the Tasks list, that shows all active tasks... How would I go about this?

Thanks! Albert

Answer 1

Could you do something with a calculated field (build an if statement) and then filter your view on this?