Populate Single Select based on another field

Hello,

Trying to populate a single select based on text in another field. Sometimes I want it automatic, sometimes it needs to be manual, so a formula field alone isn’t appropriate.

Currently running a nested IF formula, but I just need help with the syntax to make it choose X, Y, or Z from a single select field instead of printing it in the fomula field.

Any help greatly appreciated. Thanks!

The formula (which is working great for printing XYZ in the formula field):

IF(
    SEARCH("x", {Column A}),
    "X",
    IF(
        SEARCH("y", {Column A}),
        "Y",
        IF(
            SEARCH("z", {Column A}),
            "Z"
        )
    )
)

Formulas cannot control other fields. If a single select field is supposed to match the output of a formula, you have to either copy and paste the values yourself or set up an automation to do that for you.

1 Like