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

Answers
-
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.
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate
-
=(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?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!