Hi Team,

Please find the below screenshot I want to get driving predecessor 2 in row number 5

  1. Is there any way to check End date in rows number 1, 2 & 3 because predecessor mentioned 1, 2 & 3 in predecessor column then get the number of row in driving predecessor which row has max date.
  2. I have added 2 in driving predecessor because 2 will be End on 17 May 2021 then row number 5 task can start.
  3. So we can analysis row 5 task is dependent on row 2.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!