Is it possible to access the stored date of cell's modification in a formula? I need to send email notification when a process is marked complete by a user.
I see that I can view the cell history, and there is clear documentation of the date something changed, but if I could access that data in a formula in a new cell to output whatever the last modified date was - that would be incredible.
Example: =LastModifiedDate([Column2]2) would give me the last modified date of column 2, row 2.
Please add a vote for this functionality so that I can send detailed email messages based on the date that a cell changed!