Populate Single Select based on another field

Topic Labels: Formulas
2162 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


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):

    SEARCH("x", {Column A}),
        SEARCH("y", {Column A}),
            SEARCH("z", {Column A}),
1 Reply 1

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.