I use the formula {'Form Responses 1'! A1: G; 'Form Responses 2'! A2: G; ...} to get data from all sheets into one sheet. However, when the user uses a language other than English, the sheets' names are changed, and the related formulas are corrupted. Can anyone help me to solve this problem, thank you in advance.
https://stackoverflow.com/questions/66837789/the-names-of-sheets-are-changed-when-users-use-different-languages March 28, 2021 at 10:01AM
没有评论:
发表评论