Linked several sheet in one

Eric Laitenberger

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

02 community linmked sheet.docx

Genevieve P.

Hi @Eric Laitenberger

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

Eric Laitenberger

report data.docx

Hello,

You can find the example as below, thanks a lot

Genevieve P.

Hi @Eric Laitenberger

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

Eric Laitenberger

Could you wite me the formula please

Genevieve P.

Hi @Eric Laitenberger

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.

See: Formula combinations for cross sheet references

Cheers,

Genevieve

Eric Laitenberger

Could we orgnize a meeting please?

Genevieve P.

Hi @Eric Laitenberger

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:

https://help.smartsheet.com/articles/2478411-get-coaching-pro-desk-info

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

Cheers,

Genevieve