Modified Date Column Issues

SteyJ

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?

Paul Newcome

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.

Paul Newcome

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.

SteyJ

https://community.smartsheet.com/discussion/comment/400413#Comment_400413

Fantastic solution, thank you very much @Paul Newcome

Paul Newcome

Happy to help. 👍️