Returning Start and End Dates

Options

Hi All,

I am trying to get the MIN or start date of a range that only grabs from the row with the same phase. Keep in mind these Start and End dates in the project plan below have dependencies enabled.

I would like to return the MIN Start date in the Start Date Metrics column row 3 in image 1. The range is the Actual / Forecast Start Date Column in image 2. I only want the rows that contain the same phase in image 1 "Requirements" in the column Project Phase (FCM Standard) in image 2. I can't get a complete formula to return without an error. I also believe there is a nuance with the dependency date column, I read on another article about using DATEONLY.

If someone could help me with the full formula that would be amazing.

Apologies am a Smartsheet newbie.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!