英文:
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",))}
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论