Help with nested IFERROR using INDEX/MATCH - unparseable

I am trying to return a value to a destination sheet from multiple cross referenced sheets if it exists in one or multiples of those sheets. The following formula returns unparseable - and I'm not sure what I'm doing wrong. Admittedly I am a smartsheet novice.


Thanks for any help in advance.


=IFERROR(INDEX({tab_case_inv_qu_id}, MATCH([Question Name]@row, {tab_case_inv_qu_name}, 0)), "") & "|" & IFERROR(INDEX({tab_patient_case_qu_id}, MATCH([Question Name]@row, {tab_patient_case_qu_lbl},0)), "")

Answers

  • Jennifer Kurtz
    Jennifer Kurtz ✭✭✭✭✭✭

    Hi @TSmith72 - I think all you may need to do is change your '&' to '+'

    =IFERROR(INDEX({tab_case_inv_qu_id}, MATCH([Question Name]@row, {tab_case_inv_qu_name}, 0)), "") + "|" + IFERROR(INDEX({tab_patient_case_qu_id}, MATCH([Question Name]@row, {tab_patient_case_qu_lbl},0)), "")

    Does that work for you?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!