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?


Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!