I want a cell in a SP list to automatically populate/fill-in if a certain text value is present in a column in the same list. For example the list contains two columns named: Route of Flight and Spare Parts.
The Route of Flight column is filled in by the planner with a string of text, e.g. KOKC-KLIT-KDFW-KOKC. If the Route of Flight column contains KDFW then I want the Spare Parts column to auto-populate with "NEEDED". If the route of flight does not contain KDFW then the Spare Parts column should auto-populate with "NOT NEEDED".