Best Of

Ok, I like it. Picasso!

Thanks so much @KPH!!! I used the forward slash formula that you shared and this looks infinitely better than what I had before for these ROWIDs!!!

=Account@row + "- " + SUBSTITUTE([Story Category]@row, CHAR(10), "/") + " [Look " + [Look Number]@row + "]"

@Matthew L

That is excellent. If you want to have all the options from the multiselect on one row you could replace the line break with a space (or something else) using the SUBSTITUTE function:

=Account@row + "- " + SUBSTITUTE([Story Category]@row, CHAR(10), " ") + " [Look " + [Look Number]@row + "]"

This would use a forward slash instead of the space - you can use anything you like.

=Account@row + "- " + SUBSTITUTE([Story Category]@row, CHAR(10), "/") + " [Look " + [Look Number]@row + "]"

@Ami Veltrie

If your formula above works, go for it!

Here's an alternative:

=IFERROR(IF(AND(Hierarchy@row = 1, CONTAINS("Travel Week Start Date", DESCENDANTS(Task@row))), INDEX(DESCENDANTS([Start Date]@row), MATCH("Travel Week Start Date", DESCENDANTS(Task@row), 0)), PARENT()), PARENT())

Shout out if you need any help with anything.

Kelly