Formula Help

OK, fortunately even at 30,000 feet I can still read minds.  (Heading home now after a ski week).

So your lucky day was December 16th, 2018.  We got a new feature called Combined Summary Text.  It's a new kind of Summary field you can create on the left side of your relationship between Projects and Tasks.

It can summarize up to the first 25 unique values from your child record, so in your case up to 25 tasks.

The trick here is that you need to have text fields to summarize and not other field types such as dates.

My suggestion is to create a single field on the Task record to hold the Task name and the start date.

for example:

[Task Name] & " " ToText([Start Date])

Then make your combined summary text field called [Tasks and Start Dates (raw)].

So, a good start, but then you will likely complain that the field is too wide and bubble-like in appearance when viewed on our report.

So a bonus suggestion is to use this formula in a new formula text field to get it to list vertically. Maybe call it [Tasks and Start Dates].

var text value = ToText([Tasks and Start Dates (raw)]);

List("\n",
Trim(Part($value,1,";")),
Trim(Part($value,2,";")),
Trim(Part($value,3,";")),
Trim(Part($value,4,";")),
Trim(Part($value,5,";")),
Trim(Part($value,6,";")),
Trim(Part($value,7,";")),
Trim(Part($value,8,";")),
Trim(Part($value,9,";")),
Trim(Part($value,10,";")),
Trim(Part($value,11,";")),
Trim(Part($value,12,";")),
Trim(Part($value,13,";")),
Trim(Part($value,14,";")),
Trim(Part($value,15,";")),
Trim(Part($value,16,";")),
Trim(Part($value,17,";")),
Trim(Part($value,18,";")),
Trim(Part($value,19,";")),
Trim(Part($value,20,";")),
Trim(Part($value,21,";")),
Trim(Part($value,22,";")),
Trim(Part($value,23,";")),
Trim(Part($value,24,";")),
Trim(Part($value,25,";"))