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
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!