I have two columns in an excel spreadsheet. One is Entity and one is Country. I have created the Country column in SharePoint as a calculated column and pasted the list of entities into the Entity column as a choice.
For the calculated column, I want the country to be automatically populated according to the entity that has been selected from the drop down.
The calculated column works to an extent, but has started giving me the following issues:
This is a short extract from the entire formula which includes
20 IF statements and then an
&IF statement to add another 20 countries.
Issue 1: The formula is accepted, but when looking at the list the column shows PeruFALSE, PanamaFALSE, SerbiaFALSE, etc.
How can I remove this FALSE from the column name?
Issue2: I have two more countries to add (Zambia, with 9 entities and Switzerland with 2 entities). I have tried adding these to the string after the & as well as creating another &IF statement and adding them there, but SharePoint keeps telling me I have a syntax error, even though I am using exactly the same format as the previous code that worked.