Automatic addition of date on cell edition (Without script)

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

Automatic addition of date on cell edition (Without script)

问题

I am working on making it possible to see the date when a cell has been edited on a sheet, but I can only think of NOW and TODAY formulas which change every time the sheet is recalculated. I cannot use scripts as my company blocked their use.

Any idea if it is do-able?

Here is what I did for now but cannot think of a way for the date to stay when the data has been written in "B" Column.
Here is the formula I added in C2 =ArrayFormula(IF(ISBLANK(B2:B),"",today()))
It works but the date will change.

英文:

I am working on making it possible to see the date when a cell has been edited on a sheet, but I can only think of NOW and TODAY formulas which change every time the sheet is recalculated. I cannot use scripts as my company blocked their use.

Any idea if it is do-able?

Here is what I did for now but cannot think of a way for the date to stay when the data has been written in "B" Column.
Here is the formula I added in C2 =ArrayFormula(IF(ISBLANK(B2:B),"",today()))
It works but the date will change.
Automatic addition of date on cell edition (Without script)

答案1

得分: 2

这不是一个理想的方式(如脚本所做),但这应该在您的用例中起作用。尝试这个并查看它是否对您可行:

=arrayformula(if(A2:A,if(B2:B="",now(),B2:B),))

  • 在表格设置中启用迭代计算,如截图所示
  • 将“B列”格式化为时间戳格式

Automatic addition of date on cell edition (Without script)

Automatic addition of date on cell edition (Without script)

英文:

Not an ideal way(as done by scripts) but this should serve the purpose in your use-case here. Try this out & see if its feasible for ya:

=arrayformula(if(A2:A,if(B2:B="",now(),B2:B),))
  • Enable iterative calculation in sheets setting as in screenshot
  • Format the Column B to timestamp format

Automatic addition of date on cell edition (Without script)

Automatic addition of date on cell edition (Without script)

huangapple
  • 本文由 发表于 2023年5月22日 18:18:12
  • 转载请务必保留本文链接:https://go.coder-hub.com/76305163.html
匿名

发表评论

匿名网友

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

确定