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.

Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!