Multiple langages

Corentin Dal Farra

Hello everyone,

I have a company with people that works in three different langgages (English, French, Spanish). I have a planning sheet for each language but I can't make a reports or dashboard that consolidate all the data from different langages. Do you know how I could consolidate for example qualitative data, or if I can use some translation features ?

Thank you, have a nice day

Corentin

Stefan

Hi @Corentin Dal Farra,

without more detailed examples of the content of your sheets and the desired output on a dashboard, I suggest using a separate summary sheet.

In this sheet you can use defined column titles and get the needed data from the 3 source sheets with cross sheet formulas like VLOOKUP, COUNTIF, SUMIF etc. . A report from this sheet will use it's column titles and thus always deliver the defined term.

Hope this helps

Stefan

Stefan

Hi @Corentin Dal Farra,

without more detailed examples of the content of your sheets and the desired output on a dashboard, I suggest using a separate summary sheet.

In this sheet you can use defined column titles and get the needed data from the 3 source sheets with cross sheet formulas like VLOOKUP, COUNTIF, SUMIF etc. . A report from this sheet will use it's column titles and thus always deliver the defined term.

Hope this helps

Stefan

Corentin Dal Farra

Hello Stefan,

Thank you for your answer !

Corentin