Is there a way to make cells equivalent in the same sheet?

Kballiet

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?

BullandKhmer

Could you not make row 10 predecessor 22FF?

Heather Duff

@Kballiet ,

I may be oversimplifying this, but can you just insert the following formula in your oversight cell?

=[end date]@row

Kballiet

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

BullandKhmer

Could you not make row 10 predecessor 22FF?

Kballiet

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.