Assign a person based on country column - HELP

Im starting to find the Monday automations and workflow features quite restrictive the more i try and use them.

I have a board with a ‘Country’ column and when a new form entry is created (the form filler selects the country on the form) i want to assign Person ‘A’ to the new task based on the Country ‘X’.

For example;
If Country is ‘United Kingdom’ assign Person 1
If Country is ‘Spain’ assign Person 2
If Country is ‘United States’ assign Person 3

I had expected to be able to do this with the if/else function in workflows but i cant. I hopped over to automations and it doesn’t look possible their either.

Any suggestions please?

TIA

Hi Leigh,

That’s exactly why we created the Advanced Formula Booster.

This 3rd party app allows you to create formula that target any type of columns. In other words, it doesn’t use the formula column at all.

It has many unique features among which:

  • The syntax editor can accommodate up to 100 lines (ie. 100 instructions).
  • You can update multiple columns with just one formula.
  • You also have access to any column from any item from any board (whether to read or update their values).

In your case scenario, the formula’s syntax would be as simple as you wrote it:

2024-07-19_10-33-03

Let me know if you need any help. There is also an in-app ticket system. Don’t hesitate using it if you have any doubt.

There are several ways to do this natively.

I guess one way would be to use custom AI automations to populate a Text column with the country: You can input the location column and tell the AI to extract the country name.

Then you can use a workflow or automation to assign accordingly using the Text column as an if condition.