Forum Discussion

obriaincian's avatar
obriaincian
Resolver I
3 years ago

Nested IF AND Statements

Hi All,   I have what seems to be a very simple formula that doesn't seem to be working.   All I want to do is return the workstream DRI Email where the workstream DRI Email = USERPRINCIPLENAME()...
Need Help
mlsx4's avatar
mlsx4
Memorable Member
3 years ago

Hi obriaincian 

 

Var User_ = USERPRINCIPALNAME()

RETURN
IF(
    SELECTEDVALUE(Data[Workstream DRI Email]) = User_,
    SELECTEDVALUE(Data[Workstream DRI Email]),
    IF(
        SELECTEDVALUE(Data[Hiring Manager Email]) = User_ &&,
        SELECTEDVALUE(Data[Hiring Manager Email]),
        "Not a manager or DRI"
    )
)

 

I think you don't need the && condition. If you are in the "FALSE" part of the condition is because the first line is not met. That is  Workstream DRI Email is not the same as User_