智能手机经常故障
这真的让我很恼火。今天我白白浪费了四个小时在一个简单的INDEX(MATCH())上。
以下是我的原始表格:
这是我的目的地表:
这是我的十字表公式:
=INDEX({JOB_QuoteNo}, MATCH([Draft ID]@row, {JOB_DraftID}, 0))
是的,交叉表的引用是正确映射的。大约每隔一小时,Smartsheet就会同意我的观点,正确填写一栏内容,持续大约2分钟,然后又回到废话。
根据我收集到的信息,我的选择是
a)来这里寻求解决方案,并为无法回答的问题寻求答案
b)写“支持”,等上两周,他们就会用关于复杂性的模糊陈述和没有解决方案来搪塞我。
我选A,大家有什么想法吗?
根据我的经验,这种情况经常发生,而且真的不够好。
欢呼。
答案
-
ShelbyWarren ✭✭✭✭✭
@BullandKhmer这是奇怪的。当我测试它时,它对我有效。
-
Krissia B。 主持人
-
BullandKhmer ✭✭✭✭✭
这正是我的观点。是的,这应该总是有效的,它简单的索引匹配公式。但事实并非如此。这种情况经常发生。我唯一的选择是
A)在这里问一个问题,坦率地说,这个问题无法回答,只能说“这很奇怪,应该可以”
或
B)联系“支持”,他们需要两周的时间来回应,通常没有答案或没有解决方案。
打开你的游戏Smartsheet。
-
BullandKhmer ✭✭✭✭✭
在技术支持处打了个票,12小时后还在等。
-
ShelbyWarren ✭✭✭✭✭
@BullandKhmer很抱歉你遇到了问题。我上面的回答是我的直接回答,Smartsheet与我的回答无关。
谢谢你的提示。希望你能解决这个问题。
-
BullandKhmer ✭✭✭✭✭
@ShelbyWarren我知道,伙计,我不是在挖苦你。你只是碰巧帮我证明了我的观点。
-
BullandKhmer ✭✭✭✭✭
44小时前记录了一张票,到目前为止,智能表“支持”没有回应。
-
BullandKhmer ✭✭✭✭✭
64小时前记录了一张票,到目前为止没有来自Smartsheet“支持”的回应。似乎不可避免的是,我们会因为一个非常简单的索引匹配功能而错过周一上午的发布日期。
-
BullandKhmer ✭✭✭✭✭
好吧,我想我自己已经解决了这个问题……这是一个非常愚蠢的东西,本不应该成功,但却成功了。
我的源列使用公式=IFERROR(INDEX({XQU_QuoteNo}, MATCH([Xero Quote ID]@row, {XQU_ID}, 0)), "No Quote")
我将其更改为=IFERROR(INDEX({XQU_QuoteNo}, MATCH([Xero Quote ID]@row, {XQU_ID}, 0)), "")
并且I更改回=IFERROR(INDEX({XQU_QuoteNo}, MATCH([xqu_quote ID]@row, {XQU_ID}, 0)), "No Quote")
显然,这完全是无稽之谈。我觉得我已经浪费了11个小时了。还在等"支持"来支持我或者至少承认我的票。
提升你的游戏!
-
BullandKhmer ✭✭✭✭✭
哈哈哈……不幸的是,我很快就和他谈过了。在写完上面的帖子后,我回到了表格,这个问题仍然存在,没有明显的原因。
-
BullandKhmer ✭✭✭✭✭
老实说,这个垃圾让我疯狂,我对智能表所谓的支持真的很失望。
这是我今天尝试的另一件愚蠢的事情……在我的源表中,我添加了一个新列,引文2,并添加了以下公式:
=INDEX({XQU_QuoteNo}, MATCH([xqu_quote ID]@row, {XQU_ID}, 0))
然后我将源表报价无列公式更改为
=IF(ISERROR([Quote No 2]@row), "No Quote", [Quote No 2]@row)
成功了吗?是的!大概一分钟。但后来又回到了老一套,每一行都写着"不引用"
这没有任何意义,完全是在浪费我的时间。
智能表支持是不存在的,我想我在70多个小时没有承认这个问题。我们需要在非洲联盟时间周一早上上线,而这些废话正在阻止我们上线。完全不能接受的东西。
-
BullandKhmer ✭✭✭✭✭
85小时前联系了Smartsheet所谓的“支持”,到目前为止没有回应。
-
BullandKhmer ✭✭✭✭✭
这是一个世纪!110小时前给所谓的"支持"打过单。没有任何回应,我并不感到惊讶。
我们已经错过了我们的发布日期,这应该是一个简单的问题来解决。现在我们只能等着Smartsheet决定为他们的产品提供一些真正的支持。ob欧宝娱乐app手机下载
谢谢内容。
-
BullandKhmer ✭✭✭✭✭
等待智能表长达130多个小时,所谓的“支持”真是个该死的笑话。没有回应。
坦率地说,我们同时在Smartsheet和Airtable上工作,并且通常在可能的情况下将Smartsheet作为我们的首选平台。现在我们认为我们不能再在商业上冒险了。我们可以承担一个小的智能表问题使我们的整个计划脱轨的风险,没有提供支持,也没有在合理的时间范围内解决问题的途径。
如果你去Smartsheet的Facebook页面,唯一的评论是人们抱怨Smartsheet缺乏支持,以及一个可怜的Smartsheet代表为此道歉。不要付钱让人们道歉,付钱让他们做一些有用的事情。
-
BullandKhmer ✭✭✭✭✭
在几个小时的时间里,我将完成一周的等待Smartsheet“支持”。在那段时间里,我多次尝试通过这篇文章、另一篇文章、“支持”票务系统、facebook等联系Smartsheet。我至少被道歉了四次,但没有人真正抽出时间来做点什么。你最近一次与Smartsheet支持人员的对话不是以道歉开始的是什么时候?当然,这些道歉是不真诚的,很明显,Smartsheets的商业模式就是要减少所谓的支持服务的资源。
我们已经错过了最后期限,失去了一些信誉点,并且被迫免费工作2天以上来安装临时解决方案,所有这些都是基于一个简单的索引匹配公式,而这个公式并没有像预期的那样工作,应该尽快解决。它令人沮丧和尴尬,我正在认真考虑在未来的项目中推广竞争对手的软件,尽管在过去的18个月里鼓励所有客户使用Smartsheet。
谢谢内容。非常感谢。
帮助文章参考资料欧宝体育app官方888
类别
=IF([Weight (% of Completion]@row <> \"//www.santa-greenland.com/community/discussion/104518/\", [Weight (% of Completion]@row * [% Complete]@row)<\/p>
<\/p>
Then to add each piece together, you would use<\/p>
=SUM(CHILDREN([Helper Column]@row))<\/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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":106318,"type":"question","name":"Look up multiple column values from Sheet B to match values in Sheet A to return value from Sheet B","excerpt":"Hello, I'm trying to make a formula that counts values from Sheet A against multiple columns in Sheet B, if only 1 total match is found, then lookup values from Sheet A against Sheet B and based on the result, pull in the value from a Status column. If either too many same results or no results are found return a text…","categoryID":322,"dateInserted":"2023-06-12T14:48:55+00:00","dateUpdated":null,"dateLastComment":"2023-06-13T11:45:16+00:00","insertUserID":158192,"insertUser":{"userID":158192,"name":"Clare123","url":"https:\/\/community.smartsheet.com\/profile\/Clare123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-13T12:26:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-13T22:58:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":61,"score":null,"hot":3373242851,"url":"https:\/\/community.smartsheet.com\/discussion\/106318\/look-up-multiple-column-values-from-sheet-b-to-match-values-in-sheet-a-to-return-value-from-sheet-b","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106318\/look-up-multiple-column-values-from-sheet-b-to-match-values-in-sheet-a-to-return-value-from-sheet-b","format":"Rich","lastPost":{"discussionID":106318,"commentID":380268,"name":"Re: Look up multiple column values from Sheet B to match values in Sheet A to return value from Sheet B","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380268#Comment_380268","dateInserted":"2023-06-13T11:45:16+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-13T22:58:54+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":"2023-06-13T10:56:36+00:00","dateAnswered":"2023-06-13T09:33:21+00:00","acceptedAnswers":[{"commentID":380250,"body":"
Hi @Clare123<\/a> <\/p> I hope you're well and safe!<\/p> Yes, absolutely.<\/p> Here's the structure.<\/p> =INDEX({ColumnWithTheValueYouWantToShow}, MATCH(CellThatHaveTheValueToMatch@row,{ColumnWithTheValueToMatchAgainsTheCell}, 0))<\/p> I hope that helps!<\/p> Be safe, and have a fantastic week!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/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":106314,"type":"question","name":"Flexible Duration value when calculating scheduling dates","excerpt":"I have a Smartsheet which is a project plan with the Dependencies and Duration columns is being used in scheduling calculations to automatically deriving the start\/end dates for each task. However, I need the Duration to be dynamic e.g. linking cell to a cell in another sheet or to contain a formulae.. However, I cannot…","categoryID":322,"dateInserted":"2023-06-12T12:39:46+00:00","dateUpdated":null,"dateLastComment":"2023-06-13T11:22:45+00:00","insertUserID":162290,"insertUser":{"userID":162290,"name":"Mark Duddy","title":"Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/Mark%20Duddy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-13T11:41:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-13T22:07:01+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":60,"score":null,"hot":3373230151,"url":"https:\/\/community.smartsheet.com\/discussion\/106314\/flexible-duration-value-when-calculating-scheduling-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106314\/flexible-duration-value-when-calculating-scheduling-dates","format":"Rich","lastPost":{"discussionID":106314,"commentID":380264,"name":"Re: Flexible Duration value when calculating scheduling dates","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380264#Comment_380264","dateInserted":"2023-06-13T11:22:45+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-13T22:07:01+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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":"2023-06-13T11:24:19+00:00","dateAnswered":"2023-06-13T11:22:45+00:00","acceptedAnswers":[{"commentID":380264,"body":"