CODEWITHSUNDEEP
excelexcel-onlineoffice-scripts
user253529
user253529

Reputation: 11

Excel Online: Add timestamp when specific cell changes in the same row

I've been searching high and low for a solution to this but I've only found lots of answers for Google Apps instead of Excel Online. Not sure if the Google Apps script can be used in Excel Online, but here goes anyway.

What I'm looking for is guidance on how to create an 'onEdit' type script for an Excel Online spreadsheet that will insert a timestamp in the row (let's say A10) where a cell in a different column/same row (let's say N10) is changed.

I am trying to accomplish this task using Excel Online through Microsoft 365, not a locally installed Excel application. Iteration settings cannot be altered on this version to my knowledge. Could anyone provide a solution that does not involve altering iteration settings?

Any help would be HIGHLY appreciated!

Upvotes: 1

Views: 2991

Answers (2)

Tim
Tim

Reputation: 1

Macro-less formula that I finally cobbled together:

  1. Turn on iterative calculations for formulas (Options -> Formulas).
  2. Add this formula in A10: =IF(CELL("row")=ROW(A10), NOW(), A10)
  3. Drag that up and down your A column as needed

Changes to any column in a row will update its timestamp.

Upvotes: 0

Alexander Jerabek
Alexander Jerabek

Reputation: 522

While you can't use Apps Scripts in Excel, you can use Office Scripts in Excel for the Web: https://learn.microsoft.com/en-us/office/dev/scripts/

That said, there aren't any event-like structures in the feature today. You can trigger a script to run through Power Automate or a manual button push, but nothing to automatically run when a user edits a cell. Office Scripts are still in preview and we welcome your feature requests. Please head over to UserVoice and create or upvote a request for "onEdit" events.

Upvotes: 4

Related Questions