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
-
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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!