Can I use the data linked from another sheet, to populate my Sheet Summary?

M-L-B

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!

Paul Newcome

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.

Paul Newcome

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?

M-L-B

HI @Paul Newcome. Sure please see below.

Thanks.

Paul Newcome

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.

M-L-B

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! 🙂

Paul Newcome

Happy to help. 👍️