Can I link 2 sheets with a formula that feeds many date columns?
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!
Answers
-
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))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 306 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!