Hi - I have a set of data where the I have a listing of Team names and a Country that corresponds. I have 2 teams that incorrectly listed their Country names in a system and every month I have to manually update the Country that corresponds with that team. I am trying to do a formula to make this update but not sure if that is the best choice as I am not getting the expected output. Can someone please help?
Example:
Solved! Go to Solution.
You should be able to use the formula tool to update the Country field. This is a static fix but works IF [Team Name]="Team 1" OR [Team Name]="Team 3" THEN "United States" ELSE [Country] ENDIF
That worked, thank you! I was just missing the ENDIF :)