Reference date above to carry on sequence when row moved


I have a formula that calculates the end date and I want the start date to equal the end date of the previous project. How do I have a cell reference a date from the previous row when the row is moved further down the list? I can only get it to reference one cell and then I have to redo the formula for the start date for the whole column.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!