Capture Successor Task Names in a Column
Hi All,
I would like to capture the names of all successors of a given task in a column. After reviewing other similar posts on the site I feel I am close to a solution but need some help getting it over the line. Please see my work so far:
Note: My Task column is called 'Milestone / Task'
- Created a text/number auto number column called 'Auto'
- Created a text/number row number column called 'Row' - =MATCH(Auto@row, Auto:Auto, 0)
- Created a text/number Successors column called 'Successors' - =JOIN(SUCCESSORS([Milestone / Task]@row), ",")
- Created a multiselect dropdown column to convert successors into characters - =SUBSTITUTE(Successors@row, ", ", CHAR(10))
- Created a text/number column to return successor names for each task -=JOIN(COLLECT([Milestone / Task]:[Milestone / Task], Row:Row, HAS(SucHelp@row, @cell)), CHAR(10))"
The last step keeps returning the unpasrseable error. Any help would be appreciated!
Answers
-
Hi @Mellow
The structure of your formula looks correct to me! This means that the error may have to do with the formula being unable to find a matching cell or column.
Can you double check that all your column names are spelled correctly? Do they highlight in different colours in your sheet?
=JOIN(COLLECT([Milestone / Task]:[Milestone / Task], Row:Row, HAS(SucHelp@row, @cell)), CHAR(10))
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks for getting back to me! Unfortunately, I think the names are spelled correctly:
Looking at the highlights in the sheet, it also looks like the formula is targeting the right cells / columns.
-
Hi @Mellow
This screen capture is super helpful! It looks like you just have one too many closing parentheses.
After CHAR(10) < the pink ones, you should only have one blue one to close out the JOIN( function.
=JOIN(COLLECT([Milestone / Task]:[Milestone / Task], Row:Row, HAS(SucHelp@row, @cell)), CHAR(10))
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@Genevieve P. Thank you so much!! I am so embarrassed that it was that simple. I swear the last ')' looked bluish on my screen haha!
-
Haha no problem at all! 🙂 I've done that before, too.
Sometimes I remove out all of the closing parentheses and hit enter just to be safe... Smartsheet will fill in the correct number when you do that.
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives