pull value if statement help

Options
BrigitteM
BrigitteM ✭✭✭
edited 05/21/24 in Formulas and Functions

Hi Smartsheet Community,

I'm struggling with a formula. I am trying to pull the column 'Hiring Manager(s)' if the below conditions are met (below conditions are on another sheet)

'hierarchy' = 1

'Position Name' is an exact match

and offer status is not 'offer sent'

Thank you!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!