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.
    Genevieve P. Employee Admin

    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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!