Skip to main content

Update a field based on the existence of at least one value in another field

  • June 1, 2021
  • 2 replies
  • 38 views
P
Forum|alt.badge.img+7

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

    2 replies

    kuovonne
    Forum|alt.badge.img+29
    • kuovonne
    • Brainy
    • June 1, 2021

    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.

      P
      Forum|alt.badge.img+7
      • Paul_Naraine
      • Author
      • Participating Frequently
      • June 2, 2021

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

      Terms & ConditionsAccessibility statement