Formula to check box if oldest milestone?

Aidan Connell

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?

hollyconradsmith

Hi @Aidan Connell,

Try the MIN function.

https://help.smartsheet.com/function/min

=If(MIN([start date]:[start date])=[start date]@row, 1, 0)