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!


  • BullandKhmer
    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))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!