Trouble with JOIN(COLLECT) Formula - Clarification on Pred Column?

Answers

  • KLoom
    KLoom ✭

    This isn't working for me:

    =JOIN(COLLECT([Task Name]:[Task Name], Row:Row, HAS(Pred@row, @cell)), CHAR(10))"

    What is Pred in your formula? The Predecessors column or the helper? Neither is working for me.

    · Share on FacebookShare on Twitter
  • SSFeatures
    SSFeatures ✭✭✭✭✭

    Hi @KLoom,

    I think that Pred was actually a typo and should have been Predecessors from that thread. Can you post a screenshot of your sheet so that I can help you write a formula for your columns.

    Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com)

    SSFeatures - The browser extension that adds more features into SmartSheet.

    • Report PDF generator that supports grouped and summarized reports
    • Automatic sorting, sorting with filters, saving sort settings
    • Hiding and unhiding columns, and spell checking

    · Share on FacebookShare on Twitter
  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    @KLoom Exactly what steps are you following to get you to that formula? Are you able to provide some screenshots for context?

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!