Trouble with JOIN(COLLECT) Formula - Clarification on Pred Column?
Answers
-
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.
-
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) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: — Auto Sorting — Sorting with Filters — Report PDF Generation — Copy and Paste Conditional Formats — Copy and Paste Automation Workflows — Column Manager — and so many more.
-
@KLoom Exactly what steps are you following to get you to that formula? Are you able to provide some screenshots for context?
Help Article Resources
Categories
Check out the Formula Handbook template!