Forward and backward planning on the same row?

Hello good people!

I am trying to set-up a sheet where I can plan forward OR backward but on the same row. Meaning, I f I enter a date in Col A it calculates a date value in Col B, but if I instead enter a date in Col B it calculates a date value in Col A. And I need to be able to switch back and forth ad-infinitum to test out scenarios.

Is that somehow doable?

Best Answer

  • Matt Stewart
    Matt Stewart ✭✭
    Answer ✓

    You can setup 5 columns:


    Column A and B are work forward.

    Column C is duration for each row/task

    Column D and E are work backward.


    You then leave Row 1 of Column A as manual entry, and all other cells in column A should point to preceding task end in column B. Column B takes the start (column A) and adds the duration (column C).


    Column E starts with the last row of Column E as manual entry. All other cells in column E would point to the start of successor task in Column D. Column D then takes the end (column E) and subtracts the duration (column C).

Answers

  • Matt Stewart
    Matt Stewart ✭✭
    Answer ✓

    You can setup 5 columns:


    Column A and B are work forward.

    Column C is duration for each row/task

    Column D and E are work backward.


    You then leave Row 1 of Column A as manual entry, and all other cells in column A should point to preceding task end in column B. Column B takes the start (column A) and adds the duration (column C).


    Column E starts with the last row of Column E as manual entry. All other cells in column E would point to the start of successor task in Column D. Column D then takes the end (column E) and subtracts the duration (column C).

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!