Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Populate Single Select based on another field

Topic Labels: Formulas
884 1
Showing results for 
Search instead for 
Did you mean: 


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.