Time stamp challenge

I use "the copy row" function to a new sheet workaround for a time stamp if a checkbox is checked.

In my original file I use the VLOOKUP funktion to get date and time. So far that workaround is working. My problem is, that in my file where I collect all this "checked" rows, the modified date always changes (to actual date when I refresh the file and an automation was triggered. How can I have a fixed date when a new row was added? Maybe it is a problem that I already have a "created date" imported from my start file? I cant use the modified date because it is always changing.

I cannot lock the row in my start file because it is an working file.

I hope it is clear what I want? Maybe someone can help me...

And also an additional question: is it possible to calculate the difference between two date/time entries?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!