Help with a formula

Options

Hi Brain Trust

I am trying to create a formula that will pull specific info out of a rather complex sheet - has over120 columns

so in a new sheet, I want to pull just the name IF "Depart" is "OPS" and state is "WA"



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!