Formula that will pull the most up to date information from
I have a sheet that gets new entries every month and each month, the status of the project is calculated and may update. I have another sheet that holds the project information and it needs to show the most up to date status of the project. I was wondering if that is possible to do by a formula that will take the most up to date status for that project and move it into another sheet. Something similar to Max Collect but instead of largest value, it calculates the latest entry based on date.
Help Article Resources
Check out the Formula Handbook template!