Forum Discussion
create custom column using one column as a list
I have a table with two columns Submitter email and Manager email. How would I create a custom column which will display TRUE if the submitter email is found anywhere in the Manager email. as sh...
Hello there Anonymous ! You can check if this works for you:
Leader of Leader = VAR _sub = SELECTEDVALUE ( [submitter email] ) VAR _list = DISTINCT ( [Manager email] ) RETURN IF ( _sub IN _list, TRUE (), FALSE () )Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
Hello there Anonymous ! You can check if this works for you:
Leader of Leader =
VAR _sub =
SELECTEDVALUE ( [submitter email] )
VAR _list =
DISTINCT ( [Manager email] )
RETURN
IF ( _sub IN _list, TRUE (), FALSE () )Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes