Formula to return the latest date of a task if status is complete
Looking for help with a sheet summary formula that will return the last Finish date of a particular task once it is complete. I tried combining If and Max(collect) but am getting an #Unparseable error.
=If(Status@row<>"Complete","",Max(Collect(Finish:Finish, [Task Name]:[Task Name], "Task 4")))
In the below example, the result would be blank since the last Task 4 is not yet complete. But if it were complete the result would be 5/23.
Help Article Resources
Check out the Formula Handbook template!