Finding the earliest date in rows, contingent on another column's value

Ben Donahue
Ben Donahue ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

I am trying to return the earliest date in a Date Column where another column does not contain "Done".

Simple statement, but I am completely flummoxed.

Additionally, I need to return this date to a non-date column. I am using this formula to grab the earliest date that appears in the entire column in question:

=IF(MONTH(MIN(Start:Start)) < 10, "0") + MONTH(MIN(Start:Start)) + "/" + IF(DAY(MIN(Start:Start)) < 10, "0") + DAY(MIN(Start:Start)) + "/" + YEAR(MIN(Start:Start))

Even starting with that, I just don't know where to go.

The use case here is I have a to-do list and have several tasks completed. I want these tasks not to count as a start date for my reporting.

Your help is appreciated.

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!