Create custom column using IF/SWITCH and LEN function.

[SanketBhagwat]

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 · Accepted solution]

@SanketBhagwat 

You column will be 

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

[SanketBhagwat]

Thanks @Fowmy