Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 01, 2021 12:26 PM
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:
Any ideas? Thanks in advance Team! Paul
Jun 01, 2021 12:50 PM
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.
Jun 02, 2021 07:58 AM
Thanks kuovonne - appreciate the quick reply and guidance - I’ll give it a try today - I love AirTable too :winking_face: