Forum Discussion
Automatic Grouping?
I have a column that I made groups for to shrink the list and easier identify the categories: Everything that starts with NAC or Email is just grouped together under Email in the table on th...
Whats the requirement say all the Origin Starts with NAC Or Email goes to Group Email.
If this is what you want simpally create a conditional statement with If / Switch so that even if you new origin is added and it starts with NAC or Email, is hould satisfy the condition and get into Group Email.
Some thing like below
if(find("NAC",Origin,1,0)=TRUE(),"EMAIL",<Anothet If condition>)
Actually valid use of Find and If should resolve your purpose.
Let me know if it works.
Thansk
Swapnil