Automation to assign Airtable users when a record is updated in a linked field

[Rachel_Royal]

I'm trying to set up an automation in a base that will manage grant application and status reporting deadlines. 

I want the trigger to be when the field linking to the program is updated to automatically assign the appropriate team members. My setup is below, and the automation says it ran successfully, but it did not perform the action. What am I doing wrong? 

[Sistema_Aotearo]

Is your "Programme Name Value" field a formula derived from the link field? If so, it may be that the automation is working faster than the formula.

What this means is that when the automation runs to the conditional steps, nothing is in that formula field YET for it to know which condition to take. You may be able to change the conditions to read the link field directly.

Let me know if this was the issue 🙂

[bubblesbabync]

Hi, no, it is not a formula. It is just a link to another table. I've tried using both the linked field and the lookup field to see if that makes a difference, and it is not working either way. 

[brianduchek]

I just read the following on the use of "contains" elsewhere on the board:

"Has any of" requires linked records or lookup values in Airtable. On the other hand, "contains" is a string operator which works in various conditions. 

Was also wondering if contains was case-sensitive, or possibly being confused by the "/" character in that particular name.