Gantt View: Open to Today's Date Option
Comments
-
Linda Linton ✭✭✭✭
The option should work inside or outside of our network. Smartsheet needs to fix this - or remove the option.
-
Jason P ✭✭✭
I agree, we're still experiencing the issue. We have around 140 projects and 5 construction managers, and this problem is driving us crazy too. Over several weeks, the SS Tier 3 escalations engineers and our IT department worked together via email and Zoom, created shared sheets, and removed all securities and firewalls. We worked across different time zones and operating systems, both in and out of the cloud, but we still haven't found a resolution.
I last requested an update on March 7th regarding case #05782239, and essentially, the response was that the bug has been filed, and they'll reach out when it's fixed. We're still waiting for an update.
Cheers.
Forever forwards Backwards never.
-
Linda Linton ✭✭✭✭
Thanks for working with SS to that extent to hopefully resolve this for all of us! Very much appreciate the update,@Jason P!
-
Jason P ✭✭✭
Hi Linda,
By chance do you operate in on a CITRIX or simular cloud based platform? This is the latest reply from SS.
"Smartsheet's conditional check relies on "Unix timestamp" and anything that affects the date value to not respect that format could potentially cause the function to not work properly."
Cheers.
Forever forwards Backwards never.
Categories
Perfect. Thank you so much!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":106962,"type":"question","name":"Issue with cross-sheet =INDEX(MATCH()) formulas","excerpt":"I am consistently coming across an error where my cross-sheet referenced =INDEX(MATCH()) formulas are pulling the incorrect information. I am fairly certain my syntax is correct and that this is a bug. This is happening across multiple sheets I have. I have included one example, but note that I have found this to happen…","snippet":"I am consistently coming across an error where my cross-sheet referenced =INDEX(MATCH()) formulas are pulling the incorrect information. I am fairly certain my syntax is correct…","categoryID":321,"dateInserted":"2023-06-27T15:24:54+00:00","dateUpdated":null,"dateLastComment":"2023-06-28T13:34:44+00:00","insertUserID":162821,"insertUser":{"userID":162821,"name":"egardner","title":"IT Project Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/egardner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4VRPFNVQ0MWG\/n8WTXSBZQZI0N.JPG","dateLastActive":"2023-06-28T13:32:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162821,"lastUser":{"userID":162821,"name":"egardner","title":"IT Project Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/egardner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4VRPFNVQ0MWG\/n8WTXSBZQZI0N.JPG","dateLastActive":"2023-06-28T13:32:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":59,"score":null,"hot":3375841778,"url":"https:\/\/community.smartsheet.com\/discussion\/106962\/issue-with-cross-sheet-index-match-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106962\/issue-with-cross-sheet-index-match-formulas","format":"Rich","lastPost":{"discussionID":106962,"commentID":382828,"name":"Re: Issue with cross-sheet =INDEX(MATCH()) formulas","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382828#Comment_382828","dateInserted":"2023-06-28T13:34:44+00:00","insertUserID":162821,"insertUser":{"userID":162821,"name":"egardner","title":"IT Project Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/egardner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4VRPFNVQ0MWG\/n8WTXSBZQZI0N.JPG","dateLastActive":"2023-06-28T13:32:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/I4UKI5HYCYIO\/formula-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Formula.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-28T13:34:39+00:00","dateAnswered":"2023-06-28T13:01:09+00:00","acceptedAnswers":[{"commentID":382813,"body":"
The problem is with a misplaced parenthesis. That zero at the end is technically part of the INDEX function, but you want it as part of the MATCH function to denote an exact match.<\/p>
<\/p>
You have:<\/p>
INDEX(.........MATCH(...........), 0)<\/strong><\/p> You want:<\/p> INDEX(.........MATCH(..........., 0))<\/strong><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":5421,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
<\/p>