Formula to add into max end date

Heather Mize

Hello! I need help with a formula when there are multiple rows of the same name with different estimated end dates - I need the furthest date to populate in the max end date column.

Thanks for your help!

Heather Mize

Hello!

That was helpful for sure, however I still have a little hiccup. In the below example, there is one person on 3 lines on 3 different projects. The estimated end dates are listed as 12/31/21, 12/31/21 and 8/31/21. So what I need is for it to see those 3 dates and see what the latest date (12/31/21)is and populate that date in the last field on all 3 line items. I put in the formula you suggested and it gave me 3/31/22.

Any additional suggestions?

Paul Newcome

You are going to want to try something along the lines of...

=MAX(COLLECT([Estimated End Date]:[Estimated End Date], Name:Name, Name@row))

Heather Mize

Hello!

That was helpful for sure, however I still have a little hiccup. In the below example, there is one person on 3 lines on 3 different projects. The estimated end dates are listed as 12/31/21, 12/31/21 and 8/31/21. So what I need is for it to see those 3 dates and see what the latest date (12/31/21)is and populate that date in the last field on all 3 line items. I put in the formula you suggested and it gave me 3/31/22.

Any additional suggestions?

Heather Mize

It did work! So disregard! I found where the issue was on that one! :) Thanks a million for your help!!!!

Paul Newcome

Happy to help. 👍️