Solved: Re: Create custom column using IF/SWITCH and LEN f...

SanketBhagwat · ‎05-25-2021

Hi.

I want to create a custom column wherein I have to differentiate between licensed and unlicensed companies.

Condition for licensed/unlicensed companies is such that ,

If length(license no.>3) then "LIcensed" else "Unlicensed".

If someone knows how to solve this, then do let me know.

Regards,

Sanket Bhagwat

Fowmy · ‎05-25-2021

@SanketBhagwat

You column will be

License Status = If( LEN(Table[license no.]) > 3 ,  "LIcensed"  ,  "Unlicensed")

Did I answer your question? Mark my post as a solution! and hit thumbs up

Fowmy · ‎05-25-2021

@SanketBhagwat

You column will be

License Status = If( LEN(Table[license no.]) > 3 ,  "LIcensed"  ,  "Unlicensed")

Did I answer your question? Mark my post as a solution! and hit thumbs up

SanketBhagwat · ‎05-25-2021

Thanks @Fowmy

Create custom column using IF/SWITCH and LEN function.