TODAY()返回昨天或明天，具体取决于您的时区

罗伯·哈根
罗伯·哈根 ✭✭✭
编辑08/16/21 在公式和函数

嗨,社区,

在澳大利亚墨尔本，当我们使用TODAY()函数时，出现了一个有趣的问题。在一天的不同时间，它可以返回昨天的日期而不是今天的日期(这是应该的)。人们花了很长时间才承认这一点，但现在Smartsheet的几名高级员工已经证实了这一行为。

在与支持人员进行了大量讨论之后，第3层支持人员之一(非常感谢)回答说:“TODAY()函数的这个问题是已知的行为，每次单元链接、跨表格公式或自动化工作流更新表格时都会发生。原因是这些更改使用了美国太平洋时间(GMT-7或GMT-8，取决于夏令时)的硬编码服务，所以如果单元链接、交叉表格公式或自动化对表格进行了任何更改，那么在美国东部时间下午5:00之前的任何时间，您都可以通过TODAY()看到之前的日期。”我不确定美国标准时间下午5点是否正确，但在一天中的某些时候TODAY()会返回昨天——更可能是在美国标准时间上午5点之前。

这是一个巨大的解脱，因为我们现在有了一个明确的工作立场，并有了更好的理解。

在考虑了相当长一段时间后，我正在向社区寻求帮助，以确认我对这个话题的看法。我开始形成这样的观点:从不同时区修改或报告的表格存在重大问题。此外，这些时区之间的距离越远，差异就越明显。

举个例子，我在澳大利亚的墨尔本，而你在美国的纽约，我们都对同一份工作表进行了更改。让我们假设，在那个工作表中，我们使用Record a Date自动化来输入任务完成的日期。如果我完成了任务，而它在我今天的日期上打卡，你可能会把它看作是昨天。如果你完成了任务，并且它显示了你今天的日期，我可能会把它视为明天。坐在澳大利亚我无法证明这一点，所以这是我最好的猜测(我可能把我的昨天和明天颠倒过来了，但这并不会改变讨论)。

但是，话虽如此，这是一个可以(永远)解决的问题吗?Smartsheet设计人员是否意识到没有有效的解决方案，因此选择设置任意的PST/PDT时间/日期?

如果我是正确的，那么对于美国东海岸的任何人来说，这也应该是一个问题，在一天的前两到三个小时或一天的最后两到三个小时，TODAY()函数可能返回昨天或明天(不确定是哪一个，也不关心这样查找)。这种行为可能不会引起注意，因为在那个时候可能没有人在工作，或者TODAY()函数或Record a Date冲孔不在生产中使用。ob欧宝娱乐app手机下载

即使表只在一个时区中使用，TODAY()返回昨天而不是今天仍然存在问题。奇怪的是，“记录日期”(Record a Date)自动化系统似乎确实为今天打出了正确的值。

我们非常有用的第3层支持提供了一个解决方案，包括在每个生产表中实现Record a Date自动化，并安排它在每天午夜将今天的日期输入到一个基本字段中，然后使用对该字段的引用来代替所有today()函数调用。ob欧宝娱乐app手机下载初步测试表明这是正确的结果。

想法吗?讨论吗?

抢劫

标签:

答案

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    @罗伯·哈根

    我同意这是一个非常严重的问题，我认为日期记录自动化必须更新，添加时区，当有人选择这个自动化时，系统必须检查每个用户的个人设置，以采用公式中的时区。

    PMP认证

    (电子邮件保护)

    www.mobilproject.it

    ☑️你对我对你问题的回答满意吗?请帮助社区，将其标记为(已接受的答案)，我会很感激你的“投票赞成”或“有见解”

  • JennS_
    JennS_ ✭

    响应这个旧线程，因为这个问题目前发生在我身上，当使用Today()公式时，方框在实际日期之前被选中。有修复方案吗?

  • 答:巴斯
    答:巴斯 ✭
    Responding to this old thread as this issue is currently happening to me where boxes are being checked before the actual date when using the Today() formula. Is there a fix yet?<\/p>","bodyRaw":"[{\"insert\":\"Responding to this old thread as this issue is currently happening to me where boxes are being checked before the actual date when using the Today() formula. Is there a fix yet?\\n\"}]","format":"rich","dateInserted":"2022-03-30T19:27:12+00:00","insertUser":{"userID":78836,"name":"JennS_","url":"https:\/\/community.smartsheet.com\/profile\/JennS_","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zDdbc1G7yLw!xADbMann5uQ!p7v9jzckjhG","dateLastActive":"2022-04-22T18:07:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/324545#Comment_324545","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/324545#Comment_324545

    我仍然会遇到这个问题。

    有人对此有解决方案吗?

帮助文章资源欧宝体育app官方888

在Smartsheet中创建和编辑公式

交叉表引用的公式组合

内容功能列表

类别
I could solve the issue. It was a simple spelling mistake or difference between the two sheets.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-08-06 20:28:39","updateUser":{"userID":151036,"name":"Jörg Schmidt1","url":"https:\/\/community.smartsheet.com\/profile\/J%C3%B6rg%20Schmidt1","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hJjVoY907bY!!P7w61eHMiE7","dateLastActive":"2022-08-06T20:26:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":93987,"type":"question","name":"how can i copy a value from one cell to another in the same sheet","excerpt":"I have the above project plan setup The FOCUS AREA is a dropdown value. When i add children to a parent, i want the children to inherit the parents FOCUS AREA value. i created a helper column to identify children and that childs parent value for focus area. How can i automate the copy over AND still allow the user to pick…","categoryID":322,"dateInserted":"2022-08-05T17:50:56+00:00","dateUpdated":null,"dateLastComment":"2022-08-05T20:20:49+00:00","insertUserID":120623,"insertUser":{"userID":120623,"name":"Umesh Shah","url":"https:\/\/community.smartsheet.com\/profile\/Umesh%20Shah","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!B_DAgW7inuQ!GutBH5L31vo!a4sw_iKY2Cf","dateLastActive":"2022-08-05T20:19:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":120623,"lastUser":{"userID":120623,"name":"Umesh Shah","url":"https:\/\/community.smartsheet.com\/profile\/Umesh%20Shah","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!B_DAgW7inuQ!GutBH5L31vo!a4sw_iKY2Cf","dateLastActive":"2022-08-05T20:19:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":14,"score":null,"hot":3319453905,"url":"https:\/\/community.smartsheet.com\/discussion\/93987\/how-can-i-copy-a-value-from-one-cell-to-another-in-the-same-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93987\/how-can-i-copy-a-value-from-one-cell-to-another-in-the-same-sheet","format":"Rich","lastPost":{"discussionID":93987,"commentID":338859,"name":"Re: how can i copy a value from one cell to another in the same sheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/338859#Comment_338859","dateInserted":"2022-08-05T20:20:49+00:00","insertUserID":120623,"insertUser":{"userID":120623,"name":"Umesh Shah","url":"https:\/\/community.smartsheet.com\/profile\/Umesh%20Shah","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!B_DAgW7inuQ!GutBH5L31vo!a4sw_iKY2Cf","dateLastActive":"2022-08-05T20:19:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"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\/353Y6W0RK5SL\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-08-05T20:21:04+00:00","dateAnswered":"2022-08-05T19:49:10+00:00","acceptedAnswers":[{"commentID":338851,"body":"

You would use<\/p>

=PARENT([Focus Area]@row)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-08-05 20:21:04","updateUser":{"userID":120623,"name":"Umesh Shah","url":"https:\/\/community.smartsheet.com\/profile\/Umesh%20Shah","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!B_DAgW7inuQ!GutBH5L31vo!a4sw_iKY2Cf","dateLastActive":"2022-08-05T20:19:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":93984,"type":"question","name":"Multiselect Dropdown Parsing","excerpt":"Hello all, I have 3 columns in a sheet. 1 is a multi-select dropdown (\"MSD\"), 1 is a single contact (\"SC\"), and 1 is a multi-select contact (\"MSC\"). In the SC, I want to take the first dropdown value from the MSD and use it to index match a value from another sheet. In the MSC, then I want to take the remaining values from…","categoryID":322,"dateInserted":"2022-08-05T17:28:01+00:00","dateUpdated":null,"dateLastComment":"2022-08-05T19:48:02+00:00","insertUserID":151077,"insertUser":{"userID":151077,"name":"Allen M Vance","url":"https:\/\/community.smartsheet.com\/profile\/Allen%20M%20Vance","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wvjQf0zrtpU!HVPSXzyfi_0!-X5Gyhg_Kh5","dateLastActive":"2022-08-05T22:14:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-08-05T20:10:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":10,"score":null,"hot":3319449963,"url":"https:\/\/community.smartsheet.com\/discussion\/93984\/multiselect-dropdown-parsing","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93984\/multiselect-dropdown-parsing","format":"Rich","lastPost":{"discussionID":93984,"commentID":338850,"name":"Re: Multiselect Dropdown Parsing","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/338850#Comment_338850","dateInserted":"2022-08-05T19:48:02+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-08-05T20:10:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-08-05T22:14:17+00:00","dateAnswered":"2022-08-05T19:48:02+00:00","acceptedAnswers":[{"commentID":338850,"body":"

Technically yes. You can pull these values in based on the multi-select dropdown, but...<\/p>


<\/p>

We cannot currently use formulas to populate multiple USABLE contacts in a single cell even if the column is set to allow multiple. It will simply generate a text string and won't be usable in automations for notifications, update requests, etc..<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-08-05 22:14:17","updateUser":{"userID":151077,"name":"Allen M Vance","url":"https:\/\/community.smartsheet.com\/profile\/Allen%20M%20Vance","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wvjQf0zrtpU!HVPSXzyfi_0!-X5Gyhg_Kh5","dateLastActive":"2022-08-05T22:14:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">