Compare values in a single column separated by a comma

I've got a field called Concat_Team that details which team group members are in for different projects. Where there is any combination of the 5 groups (US Audit, IT Audit, APAC Audit, ERM, Analytics)) it is a collaborative project and should be noted in a new field.

I'm new to regex but seems like maybe that would help if I got the right mix? There could be lots of team members so I'd like to avoid parsing and comparing columns if possible

Ex:

US Audit,US Audit,US Audit - not collaborative because just one team listed

US Audit,IT Audit - Collaborative between different teams

ERM,Analytics - Collaborative

Thanks for any suggestions!

Preparation

Accepted answers

IraWatt

Hey @jw68937,

Heres how I would do it:

No Regex Required. The Summarize counts the number of distinct teams in each row then the formula adds on collaborative if its more than 1.

Any questions or issues please ask
HTH!
Ira

Workflow.yxmd

All comments

IraWatt

Hey @jw68937,

Heres how I would do it:

No Regex Required. The Summarize counts the number of distinct teams in each row then the formula adds on collaborative if its more than 1.

Any questions or issues please ask
HTH!
Ira

Workflow.yxmd

CathyS_Slalom

Hi @jw68937, you can create 5 flags to identify whether this Concat_Team contains US Audit, IT Audit... or not, then if the sum of the 5 flag is greater than 1 then flag as collaborative.

jw68937

These are the badass solutions I was here for! Ira's was a touch simpler so I'm marking his as solution but both were awesome suggestions! Thank you guys! Happy Friday!

Jen

IraWatt

No worries @jw68937 glad it helped 😄 Happy Friday!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703