Copy cell value and paste it as plain text in text column
Automation
- Copy Status column and paste status text in Text column
- Copy item update and paste it in text column
- Use text from text column in automation to assign appropriate Status, e.g. Text “London” - assign status by automation or from dropdown “London”
Now to achieve this you need to use external applications. This is basic functionality in automation that should be added.