Hello, I have the following table: ID Number1234567812345678x5555555555555555a55555555b I need the following output: ID NumberComment12345678 12345678xDuplicate55555555 55555555aDuplicate55555555bDuplicate All ID Number's have a "00000000" format (8 digits) and if there are any letters after this then the new column Comment should say "Duplicate". Is there a way to do this using the formula tool?

Help with Conditional Formula for a new column

Yeonsujen

Hello,

I have the following table:

ID Number

12345678

12345678x

55555555

55555555a

55555555b

I need the following output:

ID Number	Comment
12345678
12345678x	Duplicate
55555555
55555555a	Duplicate
55555555b	Duplicate

All ID Number's have a "00000000" format (8 digits) and if there are any letters after this then the new column Comment should say "Duplicate". Is there a way to do this using the formula tool?

Help

Accepted answers

atcodedog05

Hi @Yeonsujen

Here is how you can do it.

Workflow:

Hope this helps : )

Duplicate.yxmd

atcodedog05

Hi @Yeonsujen

Please find the updated solution

Workflow:

Hope this helps : )

Duplicate.yxmd

All comments

atcodedog05

Hi @Yeonsujen

Here is how you can do it.

Workflow:

Hope this helps : )

Duplicate.yxmd

Yeonsujen

Hi @atcodedog05,

This works perfectly! Thank you so much for your quick response 😀

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703