Finding the earliest date in rows, contingent on another column's value
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.
Help Article Resources
Check out the Formula Handbook template!