Skip to main content

Hi Airtable team,


Hopefully this is a simple one for most of you…



I have a single table (because I use the Org Chart app and it’s restricted to a single table).



Each record







  • has a status field and







  • also has a field to other linked fields in the table and







  • also has a lookup field for the status of linked fields







I would like to:





  • have a field that automatically looks at the status of the linked lookup field


  • determine if at least one of the values = “To do”


  • then set the status of the record in context to “To do”




Any ideas? Thanks in advance Team! Paul

You can have a formula field that computes a new status based on the lookup of the status. However, formula fields cannot change the value of another field.



IF(


    FIND("To do", {lookup of status field} & ""),


    "To do",


    {Original status field}


)


By the way, this is a community forum, and most members are not part of the “Airtable team”. We’re mostly just other people who enjoy using Airtable.

Thanks kuovonne - appreciate the quick reply and guidance - I’ll give it a try today - I love AirTable too :winking_face:

Reply


Terms & Conditions