Formula to update field for specific scenario

[kdiciero001]

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:

[TylerNa · Accepted 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

[kdiciero001]

That worked, thank you! I was just missing the ENDIF :)