How do I pull the due date from 1 smartsheet into a different smartsheet?

grosburg

One of my company teams tracks tasks and due dates in client specific sheets. Let's refer to this smartsheet as the 'Original' sheet.

I track my team's work in a separate sheet. Let's refer t this smartsheet as the 'Personal' sheet. I want to pull the due dates from the Original smartsheet into the Personal smartsheet.

I tried this to formula to pull the due date from the Original smartsheet into my Personal smartsheet.

=DATE({XYZ Implementation Plan Range 2})

I received this error:

#INVALID DATA TYPE

Notes:

1. The date I'm trying to pull from the Original sheet is a calculated date based on predecessors.
2. I merely want to pull this date into the Personal sheet so I can compare the Original dates with the Personal dates to confirm if I need to update my Jira tickets or negotiate different timelines.
3. I have created a unique column in the Personal sheet with the column type of Date to pull in the date from the Original sheet.

Thanks for your help!

L_123

you can right click the cell and link from another sheet ("Link from Cell in Other Sheet...")if the references are static, or use an INDEX MATCH with other sheet references for the range to lookup the values if you want to do it dynamically.

L_123

you can right click the cell and link from another sheet ("Link from Cell in Other Sheet...")if the references are static, or use an INDEX MATCH with other sheet references for the range to lookup the values if you want to do it dynamically.

grosburg

Thank you. I used the "link form Cell in other Sheet..." option and it appears to workas you mention it works if references are static. The date I'm trying to pull form the Original sheet updates often. The 'link form Cell in other Sheet...' doesn't update the date in my Personal sheet with the updated dates.

You explain if an INDEX MATCH will allow the dates in the Personal sheet to automatically updates when the corresponding dates in the Original sheet update? If this is an INDEX MATCH, how do I implement an INDEX MATCH?

L_123

https://www.youtube.com/watch?v=cabxWacMhKQ

In combination with:

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references#:~:text=Create%20a%20cross%20sheet%20reference,-Build%20the%20formula&text=In%20the%20help%20card%2C%20click,reference%2C%20and%20click%20Insert%20Reference.

grosburg

Thank you. This is very helpful if I want to match multiple fields. I simply want to pull a specific Original sheet end date field into a date field in my Personal sheet. When the Original sheet field changes, the changes should be reflected in my Personal sheet.