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
Check out the Formula Handbook template!