Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
Time zone clarification needed
I believe I have seen this question before but could not locate it either in the Community or in my notes. Apologies.
I am using the Smarter Business Process Smartsheet account. They are located in the UK.
I am currently in central Europe and my personal settings are set to the Berlin time zone.
我们的客户位于东部USA (not important yet, but will be later)
The Modified column is showing my time zone. That's OK.
However, the DATEONLY() function is returning the UK date.
Is there any way to fix this so that the result of the calculation is based on the visible timestamp and not the value as defined on some server somewhere?
Thanks
Craig
Comments
-
Kennedy Stomps EmployeeHi Craig-- Great question! I'm actually not sure on this, so I've reached out to our QA team to clarify what the sources for both of these values are. I'll either have them update here or update here personally once we have an answer.
-
J. Craig Williams ✭✭✭✭✭✭
Thanks Kennedy.
Craig
-
Kennedy Stomps Employee
It was brought to my attention that I never followed up on this! For future reference, here's a little more information:
System columns in Smartsheetcapturedate/timestamps in UTC butdisplaythe value in the timezone set in yourPersonal Settings. When using a function like DATEONLY(), Smartsheet is going to pull in thecapturedvalue (in UTC) which may not reflect the date in the your timezone.
A potential workaround is using a formula to concatenate the date, rather than using the DATEONLY() function, i.e. =DATE(YEAR(Modified1), MONTH(Modified1), VALUE(LEFT(Modified1, 2))), changing the "Modified" value to reflect the name of your system column.
Hope this helps!
Categories
I think you are trying to do =IF(AND(CONTAINS(Number@row, {Wave B (EMEA) - L4 Mapping}), CONTAINS(\"Be\", {Wave B (EMEA) - Country x2}), \"True\", \"False\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":111984,"type":"question","name":"Added TODAY() to a formula that works and get an error","excerpt":"Goal is to have a symbol represent how much newer the forecasted date is to TODAY. Any help would be much appreciated.","snippet":"Goal is to have a symbol represent how much newer the forecasted date is to TODAY. Any help would be much appreciated.","categoryID":322,"dateInserted":"2023-10-20T20:35:04+00:00","dateUpdated":null,"dateLastComment":"2023-10-20T22:41:11+00:00","insertUserID":162896,"insertUser":{"userID":162896,"name":"PR12x3","title":"Senior Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/PR12x3","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-20T23:36:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":163506,"lastUser":{"userID":163506,"name":"JamesB","title":"IT Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/JamesB","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nEQMY42MFGXWS.png","dateLastActive":"2023-10-20T22:40:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":31,"score":null,"hot":3395677575,"url":"https:\/\/community.smartsheet.com\/discussion\/111984\/added-today-to-a-formula-that-works-and-get-an-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/111984\/added-today-to-a-formula-that-works-and-get-an-error","format":"Rich","lastPost":{"discussionID":111984,"commentID":401050,"name":"Re: Added TODAY() to a formula that works and get an error","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/401050#Comment_401050","dateInserted":"2023-10-20T22:41:11+00:00","insertUserID":163506,"insertUser":{"userID":163506,"name":"JamesB","title":"IT Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/JamesB","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nEQMY42MFGXWS.png","dateLastActive":"2023-10-20T22:40:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/I1RSSUK7PSEV\/image.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/I1RSSUK7PSEV\/image.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/I1RSSUK7PSEV\/image.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/I1RSSUK7PSEV\/image.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/I1RSSUK7PSEV\/image.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/I1RSSUK7PSEV\/image.png"},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-20T22:38:59+00:00","dateAnswered":"2023-10-20T21:08:05+00:00","acceptedAnswers":[{"commentID":401042,"body":"
