Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Access Cell History Modified Date in a formula?

Mike Wilday
Mike Wilday ✭✭✭✭✭✭
edited 12/09/19 in Archived 2017 Posts

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! 




This discussion has been closed.