Hi there,
I have an IF clause complex that unfortunately stretches my abilities beyond the possible. Here is the challenge:
I have a column with a variety of about 15 industries, the column name is {Primary Industry} and examples include Healthcare, Justice, Public Sector, Dealerships, Fitness, Utilities, and Hospitality (there are more than 7 but lets focus on these four for the purpose of my problem).
I now have a new column called {Account ownership}. In this column I like to assign the ownership for the different accounts according to the Primary Industry they belong. I.e. all accounts with a Primary Industry “Dealerships” and “Healthcare” belong to Sven, those with “Justice” and “Public Sector” to Toni, and those with “Utilities”, “Hospitality”, and “Fitness” to Sandy.
This is how I tried to solve it:
IF(
{Primary Industry}NOT(),
IF(
{Primary Industry}=‘Dealerships’),
“Sven”,
IF(
{Primary Industry}=‘Healthcare’),
“Sven”,
IF(
{Primary Industry}=‘Justice’),
“Toni”
IF(
{Primary Industry}=‘Public Sector’),
“Toni”
IF(
{Primary Industry}=‘Utilities’),
“Sandy”
IF(
{Primary Industry}=‘Hospitality’),
“Sandy”
IF(
{Primary Industry}=‘Fitness’),
“Sandy”
)
)
)
)
)
)
)
I get the error message “Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.” I don’t think that I missed it on the number of brackets at the end as I tried to add and remove some.
Any ideas to master this complexity?
Thanks A TON!!!
Marc