Join Function + Date
Hello, I am trying to have row 1 reflect the outcome stated below and am struggling to get the right formula. I am currently using =JOIN(CHILDREN(), DATEONLY([Start Date]@row)) but want the start dates to reflect each of the corresponding Start Dates with Descriptions from the child row -- not the parent row. You can see that it's working for each of the Descriptions right now, but all the Start Dates show what's in the parent row (10/6/21).
Outcome desired: Description2 Start Date 2, Description 3 Start Date 3, Description 4 Start Date 4, Description 5 Start Date 5.
I am planning on using this formula for multiple parts of a greater grid, so hoping there's a consistent formula, rather than one that requires noting each row number.
Thank you for your help!
Help Article Resources
Check out the Formula Handbook template!