Linking a cross referenced date column to another date column in the same sheet

jmo

Hi team - I have a sheet that I'd like to link a cell within the same sheet.

The MS Due Date column is a linked to another date field on another sheet. I'd like that field to be linked to the Target Finish column for specific rows (and don't want to just copy/paste info from MS Due Date to Target Finish).

Is that possible?

Genevieve P.

Hi @jmo

What about using the formula

=[MS Due Date]@row

This will automatically reflect the same date in your Target Finish column as what's in your MS Due Date column for that row. (See: Formulas and Dates) However keep in mind that if you selected a date manually in the cell it will remove out the underlying formula.

Let me know if I've misunderstood what you're looking to do!

Cheers,

Genevieve