Multiple langages
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
Best Answer
-
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
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
Answers
-
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
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
-
Hello Stefan,
Thank you for your answer !
Corentin
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives