Record Original Date


I'm trying to automatically record the first input in a cell (e.g. Project Start Date) in another cell (e.g. Original Project Start Date).

Ideally, it'd be an automation that does this:

If “Project Start Date” is changed and “Original Project Start Date” is blank, copy “Project Start Date” to “Original Project Start Date”

I don't think that right now this is possible, but does anyone know a work-around?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!