locked
Calculated field on SP2007 RRS feed

  • Question

  • I have a calculated field that I want to set based on text in another field.  Here is what I came up with but I don't think it is correct.

    =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")

    Basically if the value equals one of the values then the set should occur if it equals none the field should be blank


    Matt Pinkston

    Wednesday, March 6, 2013 4:44 PM

Answers

  • 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

    • Marked as answer by Emir Liu Thursday, March 14, 2013 1:54 AM
    Thursday, March 7, 2013 6:36 AM