# Linked several sheet in one

✭✭✭✭✭

Hello,

I have different data in several columns according Date that I would like centralize in one sheet.

Could you help me please for this job.

You can find an example, I have three columns which are in different sheets that I would like linked according Data

## Answers

• Employee

If you have the same Date column on all three of your sheets, you can use an INDEX(MATCH formula to bring back content from one sheet based on a matching value (a matching DATE in this case).

For example:

=INDEX({Participants DEV Sheet 1}, MATCH(Date@row, {Column with Date Sheet 1}, 0))

Then you would need to write a second formula looking at the two columns in your sheet 2:

=INDEX({Participants ADV Sheet 2}, MATCH(Date@row, {Column with Date Sheet 2}, 0))

And a third one for your Sheet 3. Does that make sense? See: Formula combinations for cross sheet references

However if you have multiple rows in your other sheets with a matching date (for example 3 rows with September 27th), then you could use a SUMIFS Function instead:

=SUMIFS({Participants DEV Sheet 1}, {Column with Date Sheet 1}, Date@row)

If this hasn't helped, it would be useful to see screen captures of your 3 source sheets, but please block out sensitive data.

Cheers,

Genevieve

Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now

• ✭✭✭✭✭

Hello,

You can find the example as below, thanks a lot

• Employee

Did you try the INDEX(MATCH formula above? It looks like you could use the Date as the matching value between sheets.

Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now

• ✭✭✭✭✭

Could you wite me the formula please

• Employee

Here are the formula examples I have written above:

=INDEX({Participants DEV Sheet 1}, MATCH(Date@row, {Column with Date Sheet 1}, 0))

Then you would need to write a second formula looking at the two columns in your sheet 2:

=INDEX({Participants ADV Sheet 2}, MATCH(Date@row, {Column with Date Sheet 2}, 0))

And a third one for your Sheet 3.

Cheers,

Genevieve

Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now

• ✭✭✭✭✭

Could we orgnize a meeting please?

• Employee

Your account is eligible to book Pro Desk sessions! These are 30-minute coaching sessions over screen share where you can show your sheet set-up and have someone help guide you through the formulas I've suggested above.

Here's the link to book Pro Desk sessions: https://www.smartsheet.com/pro-desk

Here's more information:

I would recommend posting the link to this Community thread as part of your session description when you book.

Cheers,

Genevieve

Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now