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))
-
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
-
@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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives