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.


    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


  • 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