Can I use the data linked from another sheet, to populate my Sheet Summary?
Hello,
I have this sheet I'm using to track projects status and health. Almost all data are coming from my team's project plans, and I use therefore the "Link from cell in another sheet" option (this way everything is automatic and I don't need to have manual updates).
In the Summary sheet, I have setup a field in which I can see the projects that will be delivered within a month. Yet, I cannot use the cells using the delivery date info from other sheets, because it's a link and not an actual date.
My workaround is to copy/special paste (values) in another column and to use that column in the Service sheet, but the process is therefore manual and not automatic based on any change done by the projects managers in their plans.
Do you know if it's possible to use a link (the dates data coming from another sheet), in the Summary sheet?
Thanks in advance for your support here!
Best Answer
-
It should be able to be calculated even as a cell link so long as the source data is a date value and the columns on both sheets are set as date type columns.
Answers
-
It should be possible. Are you able to provide some screenshots with sensitive/confidential data removed, blocked, and/or replaced with mock data as needed?
-
-
It should be able to be calculated even as a cell link so long as the source data is a date value and the columns on both sheets are set as date type columns.
-
YES YES YES! Thank you so much! That was the missing part! The column had a text value and not a date one.
Thank you so much Paul! 🙂
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives