¨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.

JenniferN

I tried to copy this for my own formula to pull in a sample status by looking at three sheets, it is not working. Any idea what I'm doing wrong? Thanks. =IFERROR(INDEX(COLLECT({1_Program Tracker - Sample Status}), {1_Program Tracker - SKU}, @cell=[SKU Number]@row, {1_Program Tracker - Retailer}, @cell=Retailer@row), 1), "")+" "+IFERROR(INDEX(COLLECT({1a_ARCHIVE All Other Products-Program Tr.. Range 1},{1a_ARCHIVE All Other Products-Program Tr.. Range 2},@cell=[SKU Number]@row,{1a_ARCHIVE All Other Products-Program Tr.. Range 3},@cell=Retailer@row),1), "")+" "+IFERROR(INDEX(COLLECT({1_ARCHIVE All Other Products-Program Track Range 1},{1_ARCHIVE All Other Products-Program Track Range 2},@cell=[SKU Number]@row,{1_ARCHIVE All Other Products-Program Track Range 1},@cell=Retailer@row),1)""). I'm just getting "the column formula syntax isn't quite right". Thank you.

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?