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
hi
you can also create a calculated column
Column = IF(Sheet2[submitter email] in VALUES(Sheet2[Manager email]),TRUE(),FALSE())
if this post helps, accept this as a solution