Calculated Field Comparison Expression

[Wentling_Holmes]

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

[Larissa_Armand]

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')

[Wentling_Holmes]

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.