Is there a way to make cells equivalent in the same sheet?
We have oversight that goes the extension of a project.
If a 'end date' changes to later, is there a way to make the oversight cell match that and be linked verbatim. Not a predecessor but a direct match?
Best Answer
-
Could you not make row 10 predecessor 22FF?
Answers
-
I may be oversimplifying this, but can you just insert the following formula in your oversight cell?
=[end date]@row
-
It's a calendar field so it's not allowing me to put in a formula calculation.
I essentially need the Finish calendar date (last column in the screenshot) to match another cell in the Finish calendar column directly.
So in the screenshot attached, when the end date in row 22 changes, I would want the end date in row 10 to be linked to change to that as well
-
Could you not make row 10 predecessor 22FF?
-
Thank you. @BullandKhmer that halfway works, however, it maintains the # of days. So it shifts back vs. adding on additional days when deadlines shift out.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!