如何停止在其他工作表上重新分配公式值的Google工作表 [英] How do I stop google sheets reassigning formulae values on another sheet

问题描述

我的问题如下:

我让Formsite自动将行添加到Google表格中的工作簿中.另一张纸格式化某些数据捕获器的数据，只需要复制并粘贴到另一个程序中即可.我的问题是，每次formsite添加另一行时，映射似乎都变得很麻烦.

I have formsite automatically adding rows into a workbook in Google Sheets. Another sheet formats the data for some data capturers to just do a copy and paste into another programme. My issue is that the mapping seems to go haywire every time formsite adds another row.

例如: 如果复印纸上的a列有

For example: If column a on the copy sheet has

= formsitesheet！a1

=formsitesheet!a1

= formsitesheet！a2

=formsitesheet!a2

= formsitesheet！a3

=formsitesheet!a3

当formsite添加一行而不是刚刚更新的值时，它将更改为 = formsitesheet！a2

When formsite adds a row instead of the values on the just updating it changes it to =formsitesheet!a2

= formsitesheet！a3

=formsitesheet!a3

= formsitesheet！a4

=formsitesheet!a4

是否有改变这种行为的方式?

Is there anyway to change this behaviour?

谢谢

推荐答案

这是一种解决方法.将INDIRECT()与ROW()一起使用

Here is a workaround. Use INDIRECT() with ROW()

=INDIRECT("'formsitesheet'!A"&ROW(A1))

或

=INDIRECT("'formsitesheet'!A"&ROW(A1)+X)

其中X是您的偏移量.

Where X is your offset.

希望这会有所帮助

这篇关于如何停止在其他工作表上重新分配公式值的Google工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！