Return MIN date from another sheet if criteria are met

Options

Hello community!

I am trying to return a date value from another sheet if criteria are met.

TIME SHEET

The date on the first row uses this formula:

=DATEONLY(MIN({StartDate})) + ""

It is pulling this information from the PROJECT PLAN SHEET start date column:

I need the formula in the highlighted cell of the TIME SHEET to return the MIN date from the 'Start Date' column in PROJECT PLAN SHEET if it is part of the feasibility section.

Is it a combination of DATEONLY(MIN for the date and also INDEX(MATCH for the word "Feasibility"?


THANK YOU IN ADVANCE!

Regards,

Sam

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!