If/Or with an Index Match

Catherine Shea
Catherine Shea ✭✭✭
edited 02/16/23 in Formulas and Functions

My formula is able to locate from a reference sheet the return value of the HC Request Status1 as a match, however I need to add that when a [Job Class] = "Associate" the HC Request Status = Approved. I am not sure how to correct my formula as I am getting an error 🤨 "unparseable"

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!