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! Go to Solution.
Comma is missing from the end of the 2nd row.
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.
User | Count |
---|---|
41 | |
25 | |
25 | |
17 | |
12 |