Skip to main content

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.

Reply


Terms & Conditions