If/Or with an Index Match
Best Answer
-
Thank you!!!! 😀 That worked I am so grateful for your response.
Answers
-
@Catherine Shea I think you saying that if the Job Class = Associate, the HC Request Status should be set to Approved, but if Job Class <> Associate, run the index/match formula to pull the HC Request Status from the other sheet, yes?
You just need an IF formula, with the index/match as the "value if false" in the IF.
=IF([Job Class]@row = "Associate", "Approved", (IFERROR(INDEX({HC Request Status1}, MATCH([HC Request ID #]@row, {HC Request ID}, 0)), "")))
Logic: If Job Class is Associate, set this cell to Approved; otherwise, run this index/match formula.
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Thank you!!!! 😀 That worked I am so grateful for your response.
-
Fantastic, happy to help!
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
Check out the Formula Handbook template!