Saving original cell value in another cell
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?
Comments
-
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.
-
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
Help Article Resources
Categories
Check out the Formula Handbook template!