Link to single select fields together

[Patrick_Hammers]

Hey guys, i want to try the following:
I have two single select fields.
(Status) with “in Stock” and “on Location”
and
(Project) with “Project 1” and “Project 2” and “Project 3”

So my issue is: i want to have the (Status) changed to “on Location” if i select for example “Project 1” or “Project 2” and if i don’t select any (Project) it should say “in stock”

i hope you understand what i mean. I just want to have a link so if i change project it will also appear on status.

Best
Patrick

[AlliAlosa]

Unfortunately, you can’t change a single-select field conditionally within Airtable, but here is a workaround…

Change your single select field {Status} to a formula field, with the formula:

SWITCH({Project}, "Project 1", "On Location", "Project 2", "On Location", "In Stock")

The last value given (“In Stock”) is the default/fall-back value for when {Project} doesn’t match any of the previous values in the formula.

[Patrick_Hammers]

AlliAlosa:

SWITCH({Project}, “Project 1”, “On Location”, “Project 2”, “On Location”, “In Stock”)

thanks it is working, sad that i can´t use the “colored” status as before - but this should work

[AlliAlosa]

Excellent - I agree, I wish we had the option to assign a formula to each single-select option so we could keep the pretty colors :frowning:

Another option, though, is to use emojis in your formula text, just to make it a little more fun!