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)), "")
