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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!