Row Filter Slice With IF OR Statement

I have a slice that I want expressed if one of two columns equals a user email. I have created a task list which would display a specific task for a user if either the Requestor or Assigned Team Member's email shows in either of those columns. And if the condition of the task <>"Resolved"

My objective is to show both the Requestor and the Assigned team member the same task.

IFS([Requestor] OR [Assigned] = useremail(), [Status]<>"Resolved")

Solved Solved
0 4 159
1 ACCEPTED SOLUTION

Comma is missing from the end of the 2nd row.

View solution in original post

4 REPLIES 4

The Slice Row Filter Condition would need to use a combination of AND() & OR() like so:

EDITED:  Added missing comma in red

AND(
[Status]<>"Resolved",
    OR(
[Requestor] = USEREMAIL(),
[Assigned] = USEREMAIL()
)

 

I am getting this error.... "Condition AND(([Status] <> "Resolved")) has an invalid structure: at least 2 subexpression(s) required"

Comma is missing from the end of the 2nd row.

Yes it was!  I updated the post.

Top Labels in this Space