Google Sheets – 当提交新表单时,在特定列中自动填充单元格

huangapple go评论127阅读模式
英文:

Google Sheets - Autofill a cell within a certain column when a new Form is submitted

问题

=ARRAYFORMULA(IFS(ROW(A:A)=1,"替换?",A:A="", "", TRUE, K:K="N"))

我正在尝试让一个单元格自动更新,以便可以应用条件格式,但表单通过创建新行提交到关联表格的方式确实会对其产生影响。我一直在尝试使用数组公式,但似乎离成功还有一些差距,我不确定我哪里做错了。

我现在的公式:
=ARRAYFORMULA(IFS(ROW(A:A)=1,"替换?",A:A="", "", TRUE, K:K="N"))

我希望它实现的目标:
当提交新表单时,我希望列K中的新单元格更新为字母N,希望这能触发我的条件格式来更新行。K1中的单元格需要命名为“替换?”,现在似乎这方面运作正常。

英文:

I'm trying to have a cell auto-update so it can apply conditional formatting but the way Forms submits to a linked Sheet via making a new row is really messing with it. I've been trying to use an array formula but it just seems a little off from working and I'm not sure where I'm going wrong.

The formula I have now:
​=ARRAYFORMULA(IFS(ROW(A:A)=1,"Replaced?",A:A="","",TRUE,K:K="N"))

What I want it to accomplish:
When a new Form is submitted, I want the new cell in column K to update with the letter N, and hopefully that triggers my conditional formatting to update the row as well. The cell in K1 needs to be named "Replaced?" and that seems to work fine for now.

答案1

得分: 1

尝试将此内容放入“单元格 K1”中:

={"Replaced?";index(if(len(indirect("A2:A")),"N",))}
英文:

Try this in Cell K1:

={"Replaced?";index(if(len(indirect("A2:A")),"N",))}

huangapple
  • 本文由 发表于 2023年3月10日 00:30:42
  • 转载请务必保留本文链接:https://go.coder-hub.com/75687465.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定