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

Answers

  • Michelle Choate 2
    Michelle Choate 2 Community Champion

    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

  • Matthew R
    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?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!