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?


Jacob Stey

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!