英文:
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.
答案1
得分: 2
这不是一个理想的方式(如脚本所做),但这应该在您的用例中起作用。尝试这个并查看它是否对您可行:
=arrayformula(if(A2:A,if(B2:B="",now(),B2:B),))
- 在表格设置中启用迭代计算,如截图所示
- 将“B列”格式化为时间戳格式
英文:
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
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论