Can I link 2 sheets with a formula that feeds many date columns?

Agata Wozniak

Dear All,

would you please advise if this is possible?

if yes, would that be a combination of JOIN/ COLLECT/ IF / AND?  

If no, is there a way around it?

I need the dates in these 10 columns:

 to feed into these 2 date columns:

The condition is that Discovery Start Date has to feed into Phase Start Date when the activity is Discovery. And same way all the other activities: Test Start date to feed Phase Start when the activity is Test etc..

Thank you in advance!!

And have a lovely weekend!

BullandKhmer

I'm assuming your source sheet has multiple rows and you want to reference a single row, is that correct?

I'd use cell linking, seems easier.

But you could use a bunch of index match formulas, i.e.

INDEX({Discovery - Start},MATCH([project id]@row, {project id},0))