07-31-2020 07:31 AM
Hello, i'm trying to compare users and bucket them but I'm having difficulty making an expression that works. this could just be my failing I was hoping someone may be able to help.
Iif(Contains([Completion person], In ('person1', 'person2', person3')), 'Provider', 'Member')
Any help would be appreciated
07-31-2020 07:36 AM
Hi Scot,
How about this:
Iif([Completion person] = 'person1' OR [Completion person] = 'person2' OR [Completion person] = person3'), 'Provider', 'Member')
ETA: It looks like this would work too, really, if you just leave out the Contains part of what you had originally:
Iif([Completion person] In ('person1', 'person2', 'person3'), 'Provider', 'Member')
07-31-2020 07:45 AM
Thank you! This should work, I was just kind of trying to be lazy and not have to worry about including the EXACT format of the name.
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.