Formula to check box if oldest milestone?

Hi there,

I have a set of project plans that I wish to summarize in one report, and in that report I only want to know the oldest (aka soonest) milestone that is not completed for each project. To get to that, I figure I will have a checkbox column in every project plan, with a formula that checks the box if it is a milestone, not completed, and also the soonest.

Example of the data I have to work with below. I figure this will be an IF() with AND() checks on the multiple conditions, I just can't figure out what to put into the IF() to check if it is the oldest milestone. Any ideas?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!