Forum Discussion
Sam_Chig
Nov 05, 2021Copper Contributor
Update date when a certain cell is changed
I want the current date to be updated when I change the Attempt # column. Date is column G and Attempt # is column I. To be clear, when I change attempt # in a cell, I want the Date Called corre...
KraigKahl
Copper Contributor
Hi, is there a way to do this with a formula instead of a macro?
HansVogelaar
Jul 21, 2023MVP
It's possible to use a formula to record the date/time when a cell is first changed, but the result won't change when the cell is changed again. The latter can only be accomplished through VBA or Office Script.
- KraigKahlJul 21, 2023Copper ContributorThank you for the prompt response!