asked on

Updating an sharepoint list form formula

I have the following SharePoint list formula on a custom list field but I need it slightly altered...

=IF(ISNUMBER(FIND("CIVILIAN",UPPER(Hierarchy))),"Civilian",IF(ISNUMBER(FIND("HEALTHCARE",UPPER(Hierarchy))),"Healthcare",IF(ISNUMBER(FIND("DEFENSE",UPPER(Hierarchy))),"Defense",IF(ISNUMBER(FIND("CONSULTING",UPPER(Hierarchy))),"CS",IF(ISNUMBER(FIND("SLED",UPPER(Hierarchy))),"S&L","")))))

This is n a field called segment but would love to have it only do the ifs following the first if segment is now not empty... I also need to add these to the bottom...

=IF(ISNUMBER(FIND("CIVILIAN",UPPER(Lead Sales Region))),"Civilian",IF(ISNUMBER(FIND("HEALTHCARE",UPPER(Lead Sales Region))),"Healthcare",IF(ISNUMBER(FIND("DEFENSE",UPPER(Lead Sales Region))),"Defense",IF(ISNUMBER(FIND("CONSULTING",UPPER(Lead Sales Region))),"CS",IF(ISNUMBER(FIND("SLED",UPPER(Lead Sales Region))),"S&L","")))))

Rainer Jeschor

Hi,
sorry but I could not fully understand your question. Can you please explain your expected result again?
You currently have a calculated column named Segment which contains your first formula (result based on a string in the hierachy field). But I dont get the meaning of your second formula.
Thanks.
Rainer

Matt Pinkston

ASKER

This is what I tried but get an error

=IF(ISNUMBER(FIND("S&L",UPPER(Lead Region Name))),"S&L",
IF(ISNUMBER(FIND("Defense",UPPER(Lead Region Name))),"Defense",
IF(ISNUMBER(FIND("Healthcare",UPPER(Lead Region Name))),"Healthcare",
IF(ISNUMBER(FIND("Civilian",UPPER(Lead Region Name))),"Civilian",
IF(ISNUMBER(FIND("CIVILIAN",UPPER(Hierarchy))),"Civilian",
IF(ISNUMBER(FIND("HEALTHCARE",UPPER(Hierarchy))),"Healthcare",
IF(ISNUMBER(FIND("DEFENSE",UPPER(Hierarchy))),"Defense",
IF(ISNUMBER(FIND("CONSULTING",UPPER(Hierarchy))),"CS",
IF(ISNUMBER(FIND("SLED",UPPER(Hierarchy))),"S&L",""))))))))

ASKER CERTIFIED SOLUTION

Rainer Jeschor

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial