Need Help with Formula, want all project summary sheet to record most recent step completed
Hi I have a summary sheet that contains all projects that my various PM are working on, the project summary sheet looks like this:
Each project then has its own sheet for the PMs to keep track of what steps have been completed for the project, looks like this:
On the summary sheet in the "most recent step completed" column I want the row to look to its related individual project sheet and pull the step name from the first column for the step that was most recently completed based on the date entered in the date complete column.
Is this possible?
Help Article Resources
Check out the Formula Handbook template!