Successor Column Issue

sdb60411
sdb60411
edited 03/25/24 in Formulas and Functions

I am having trouble with adding a successor column. I have pulled up the example project plan and added =JOIN(SUCCESSORS([Task Name]@row),”,”) to my Successor Column. I keep getting an error (#UNPARSEABLE). Task Name is my primary column. I have tried other columns (Start, etc.) and I have tried without the [ ].

I am probably missing something simple, but I cannot get this to work.


Best Answer

Answers

  • brianschmidt
    brianschmidt ✭✭✭✭✭✭

    Hmm, this definitely should be working. I am noticing that your Task Name reference isn't lighting up (recognizing it as a valid reference) like so:

    When writing the formula, try clicking on the Task Name cell in that row. It's possible there is a space that somehow got on the end of the column name that is throwing it off. I've found @row references to be incredibly case-sensitive.

    If that doesn't work, you can always try simply refreshing the page. Sometimes, oddly enough, that does the trick.

    Hope this helps!:)

  • sdb60411
    sdb60411
    Answer ✓

    Yes. That did the trick.

    Thank you!!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!