pull value if statement help

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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!