Forum Discussion
Copying a formula down doesn't yield results
Hi Sergei,
Yes, those naming conventions are correct. Unfortunately I am not permitted to upload the document, however I have attached a couple of screen shots so you can hopefully see what I'm talking about. I'm trying to get the start/end dates for each project (each of which has multiple tasks listed under them, with different dates on the project tracker page - table name is 'tracker') to automatically go into the project overview page (table name is 'overview'). For some items it appears to be working, for others i still only get 0-Jan-00, even though the formulas are the same.
Hi Erin,
Thank you for the screenshot, it's more clear now. In general your formula shall work, but only if you use it as array one (use Ctrl+Shift+Enter to enter the formula). Regular (non-array) formula equivalent could be
=AGGREGATE(15,6,1/(Tracker[Project Name]=[@[Project List]])/(Tracker[Start]>0)*Tracker[Start],1)
Both are in attached file.
That's fantastic, thank you so much!
Would the end formula be the same (obviously using End instead of Start) or would there be other changes? Trying to find the latest End date.
Erin, that's
=AGGREGATE(14,6,1/(Tracker[Project Name]=[@[Project List]])/(Tracker[End]>0)*Tracker[End],1)
, please check https://support.office.com/en-us/article/aggregate-function-43b9278e-6aa7-4f17-92b6-e19993fa26df
File is attached