Attempting to populate the value of a cell based on the value of a different cell

Draykov
Draykov ✭✭✭✭

So, the question posed below seemed very similar to what I'm trying to accomplish, and I did make some headway...until I started including multiple selection possibilities.

I want my "Pathways" column to assign one of five values based on the value of the "Discipline" column on the same row. There are 40+ Discipline values to choose from.

The end goal is for the form submitter to provide the "Discipline" from a drop-down and for the sheet to populate the "Pathways" cell based on that "Discipline."

For instance:

IF DISCPLINE = X, PATHWAY = Y, where more than one "Discipline" can belong to a single "Pathway."

ACCT, ACNT, BMGT [Discipline] = Business & Industry [Pathway]

ARTS, DANC, DRAM = Arts & Humanities

ANTH, EDUC, PSYC = Human & Public Service

CHEM, BIOL, MATH = STEM

N/A = ADMIN

I made the most headway with =IF(OR statements, until things broke. I've also looked some into =INDEX/MATCH, but...I'm at a loss.

THANKS!

Reference question

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!