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?

Find more posts tagged with

Accepted answers

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.

All comments

Paul Newcome

You will need to insert a text/number column and use

=[Modified Date]@orw + ""

plus quote quote

SteyJ

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

Fantastic solution, thank you very much @Paul Newcome

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.