¨The column formula syntax isn't quite right¨ Error

System

This discussion was created from comments split from: IFERROR(INDEX(COLLECT Pulling Data from 3 different sheets into one single column.

Michelle Choate 2

Have you tried removing the @cell in all of these? I do not believe it is necessary for any of your situations.

Also as an aside - It is best practice to name your reference ranges as you have done in the first part of this equation. You might want to update your references in the second half so that way when you are trying to analyze this formula months from now, you know what you are pulling in.

Matthew R

=(IFERROR(INDEX(COLLECT({Pass/Fail}, {Unit Part Number}, @cell = [Part #]@row, {Sales Order Number}, @cell = Order@row), 1), "") + " " + IFERROR(INDEX(COLLECT({Pass/Fail 1}, {Unit Part Number 1}, @cell = [Part #]@row, {Sales Order Number 1}, @cell = Order@row), 1), "") + " " + IFERROR(INDEX(COLLECT({Pass/Fail 2}, {Unit Part Number 2}, @cell = [Part #]@row, {Sales Order Number 2}, @cell = Order@row), 1), ""))

Have you tried ensuring there is a space between the initial comma and the @cell statement? My final formula has spaces there, at first glance I am not sure if that would effect your formula?