group

[smilingjohn]

Hi ALl

Hi i have a field name called lstatus and it has many type of status in it i wanted to grupou the below mentioned status as Close and other should be as it is

if(match(Lstatus('Closed','Cannot-Re-Create','Working-As-Designed','Training','Duplicate','Obsolete','Further-Discussion-Required'),'Close',LStatus

Can someone please suggest me on this ?

[Chanty4u]

yes bro  your's only  the approach is correct or not am asking

[sunny_talwar]

Applymap with mapping load is definitely the way to go...

[Chanty4u]

Ok bro thank you