Hi Pinkston,
Following formula should meet your requirement.
IF(ISNUMBER(FIND("CIVILIAN",[Hierarchy])), "Civilian", IF(ISNUMBER(FIND("HEALTHCARE",[Hierarchy])), "Healthcare", IF(ISNUMBER(FIND("DEFENSE",[Hierarchy])), "Defense", IF(ISNUMBER(FIND("CONSULTING",[Hierarchy])), "CS", IF(ISNUMBER(FIND("SLED",[Hierarchy])),
"S&L", "")))))
Let me know if there is any question.
Thanks & Regards,
Emir Liu
TechNet Subscriber Support in forum
If you have any feedback on our support, please click
here.
Emir Liu
TechNet Community Support
