How do I pull the due date from 1 smartsheet into a different smartsheet?
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:
- The date I'm trying to pull from the Original sheet is a calculated date based on predecessors.
- 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.
- 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!
Best Answer
-
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.
Answers
-
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.
-
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?
-
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!