I am unable to get this SIMPLE calculated field to work. Note that I am not a programmer and do not use codes a lot. So please help in details.
I have a SharePoint list where I want to get a simple calculated field based on 2 column selections (both have multiple choices).
I have a field with region/country choices and one with Roles.
So, if I select CANADA from my [REGION/COUNTRY] field, and then select CCC as a role in the column [Role] I want the result in that calculated field to be "1971".
So, you get that I have multiple possibilities to add in my formula Can you help on the recipe?