Hello dear experts,
I currently need a way to automate timestamps at Excel Online. I have seem tutorials and other posts here at the forum, but they usually both use iteractive self declaring functions, or VBA, both of which I cannot use at excel online. Also, office scripts is not working at the moment for some reason.
With those restrictions, I have to automate the current date in a spreadsheet, as follows:
If a user access the spreadsheet, and changes a certain cell (for example, D15), the cell B3 has to update to the current date. This is so we can can keep track if someone makes changes to a specific process.
As said earlier, that would be "easy" if I had access to most of excel in a desktop, but as I'm stuck with the online/cloud version, it gets tricky. Would it be possible using office scripts only?
Any sugestions would be greatly appreciated. Thanks in advance!
I currently need a way to automate timestamps at Excel Online. I have seem tutorials and other posts here at the forum, but they usually both use iteractive self declaring functions, or VBA, both of which I cannot use at excel online. Also, office scripts is not working at the moment for some reason.
With those restrictions, I have to automate the current date in a spreadsheet, as follows:
If a user access the spreadsheet, and changes a certain cell (for example, D15), the cell B3 has to update to the current date. This is so we can can keep track if someone makes changes to a specific process.
As said earlier, that would be "easy" if I had access to most of excel in a desktop, but as I'm stuck with the online/cloud version, it gets tricky. Would it be possible using office scripts only?
Any sugestions would be greatly appreciated. Thanks in advance!