Saving original cell value in another cell

Keith V
Keith V ✭✭✭
edited 12/09/19 in Formulas and Functions

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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!