OR(CONTAINS([Ansvar],USEREMAIL()),CONTAINS([Eposter],USEREMAIL()))
The above is working ok, but I’d like to add another condition described below to the formula, but writing out it’s logic is beyond my skills…:
CONTAINS([Eposter], GroupAddress[GroupID]) if USEREMAIL() is the same as GroupAddress[UserEmail]
(GroupAddress is a table that contains the two columns UserEmail and GroupID generated from Google groups.)
Sorry in advance if my explanation isn’t good enough.
Solved! Go to Solution.
Thank you very much. Could you please try the following
OR(
[Ansvar] =USEREMAIL(),
IN([USEREMAIL(), [Eposter]),
COUNT( INTERSECT([Eposter],
SELECT(GroupAddress[GroupID],[UserEmail]=USEREMAIL() ) ))>0
)
Please test well for your requirements.
User | Count |
---|---|
17 | |
12 | |
9 | |
4 | |
4 |