How do I find/calculate the available (latest) date from multiple rows WHERE there is a condition

edited 06/02/23 in Formulas and Functions

Intent: Calculate date team member is available

I have a resource planning sheet, which lists a number of activities (by row) for team members. Each row describes the team member, activity, the status, and the start and end date.

How do I find the latest end date for each team member, where there activity is 'In Progress'?

In the attached screenshot, I want to calculate and store for:

Team Member 1 is available from: 17/08/23

Team Member 2 is available from: 30/06/23


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!