Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions