问题描述
我的问题如下:
我让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工作表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!