Modified Date Column Issues
I am pulling the modified date and converting it to a value between 0000 and 2359 when a checkbox is selected.
My issue is that, many times a user with a different time-zone setting will come into the sheet and when they do that, it automatically modifies ALL of the columns (even if they're locked).
Is it possible to stop the modified column from being changed when a row is locked by time zone differences?
Sincerely,
Jacob Stey
Best Answer
-
You will need to insert a text/number column and use
=[Modified Date]@orw + ""
plus quote quote
To turn it into a text value. You would then use a copy row automation set to trigger at whatever point you want to capture this. It will then be static data in the second sheet where you can use a formula with cross sheet references to pull the static date/time stamp back over into your working sheet.
Answers
-
You will need to insert a text/number column and use
=[Modified Date]@orw + ""
plus quote quote
To turn it into a text value. You would then use a copy row automation set to trigger at whatever point you want to capture this. It will then be static data in the second sheet where you can use a formula with cross sheet references to pull the static date/time stamp back over into your working sheet.
-
Fantastic solution, thank you very much @Paul Newcome
Sincerely,
Jacob Stey
-
Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!
