Saving original cell value in another cell

Keith V

I have a cell that holds a target date (Target Go-Live Date) and another cell that I want to hold the original date entered in the target date cell.  This way if the Target Go-Live Date is changed, the other cell (Original Target Date) has that date saved in it.    My thought was to only set Original Target Date = Target Go-Live Date when Original Target Date is blank.   My formula is this:

=IF([Original Target Go-Live]1 = "", [Original Target Go-Live]1 = [Target Go-live Date]1)

This gives a circular reference though.  Is there any way to carry out the action I want using formulas?

Mike Wilday

I am not sure that there is a way to accomplish this. If you use a formula it will copy the data from the first column. When that column changes it will change as well. A third party tool like Zapier might be an option... it can replicate some date stamping activity but I haven't personally played with it. J. Craig Williams could probably speak more on the topic. 

J. Craig Williams

The Zap described here:

http://ronin-global.com/2016/12/11/smartsheet-fixed-date-upon-completion/

has been adapted to do other 'toggle related' functions.

It can not be done in Smartsheet with the existing functionality.

Craig