Returning Start and End Dates
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.
Help Article Resources
Check out the Formula Handbook template!