field type would still be a formula checkbox. it would be checked if the record owner was in your user list. If you want the user list and evaluation in two separate fields, I can update. :)
Morning Katlyn,
I was trying the formula today and i'm running into an issue. The formula wouldn't run as written, as it was expecting user but found text. We then substituted ToText with ToUser and the formula was accepted, but now every record is checked, even if the SME does not match the Record Owner. What data could i provide that might help with this?
I think there is an error when creating the user list.
var userlist users =
ToUserList(
// extracts the text between parentheses in [SME] and appends the email domain
ToText(Part(Part([SME], 2, "("), 1, ")") & "@somecompany.com"),
//record owner
[Record Owner]
);
When making your user list, why are we appending [Record Owner] to that list and then checking if the record owner is in the list? That's like saying, check if Record Owner is included in Record Owner, thus, everything is checked. Remove the [Record Owner] from the user list above.
------------------------------
Mike Tamoush
------------------------------
How do you write it in such a way that you compare the SME field, converted into a user list, to the record owner without including the record owner as part of the userlist field?
The Record Owner should not need to be a user list.It's as if you have a list of letters:
A,B,C,D and you want to check if a single letter is within that list. You would just do:
contains([Letter List], "B")
In your case:
contains($Userlist, [Record Owner])
