Formula to add into max end date
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!
Best Answer
-
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?
Answers
-
You are going to want to try something along the lines of...
=MAX(COLLECT([Estimated End Date]:[Estimated End Date], Name:Name, Name@row))
-
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?
-
It did work! So disregard! I found where the issue was on that one! :) Thanks a million for your help!!!!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!