Lookup Formula Help


I'm looking for a formula that can look at the highlighted field and only pull out the option I want. example in column 30 it will look at the highlighted column and if PLD is in there it will answer PLD and ignore everything else. The highlighted field a person can select multiple departments and I need to be able to separate them out individually is that possible?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!