Skip to main content

I would like to change the assignee of a project (assignee field) based on the current status (single-select field).


Is it possible to do this, and I am just missing it? My only current thought was to write a python function that runs every second to check for this and change the assignee accordingly.


If not, where is the best place to request such a feature?

Hi @Jordan_Violet - you could simply have a formula field based on the status field:



SWITCH(Status, 'Not started', 'Jim', 'In progress', 'Jane', 'Completed', '')


JB

Thanks for the reply! Unfortunately, because it is a function field and not an assignee field, I won’t get the benefits of the assignee field such as notifications.


I wrote a python lambda function that runs every one second, currently, that checks for me.

For those that come through here later, I came up with my own solution, here: community[dot]airtable[dot]com/t/add-ability-to-change-assignee-based-on-conditions/22604/3?u=jordan_violet

Reply


Terms & Conditions