#除零错误-其他分辨率不工作
我试图解决一个#除零错误。我看过其他的解决方案，但它们对我不起作用。下面是我使用的公式:
=ROUNDUP(([锚安装小时]@row / {Amazon - Brownfield -优先级站点-设置范围2}/[#锚技术人员]@row)， 0)
我尝试了IFERROR(ROUNDUP决议，它给了我一个无效的参数。
建议吗?
最佳答案
-
kdashnaw ✭@Andree Stara非常感谢您的快速回复和帮助!这个公式现在起作用了!
答案
-
她名叫Stara ✭✭✭✭✭✭我希望你一切安好!
试试这样的方法。
= IFERROR(ROUNDUP([Anchor Install Hours]@row / {Amazon - Brownfield - Priority Sites - Set Range 2} / [# Anchor技师]@row)， 0)，"ERROR MESSAGE")那有用吗?
我希望这能有所帮助!
注意安全，祝你有一个美好的一周!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请通过以下方式支持社区将其标记为有见地/投票赞成或/和作为可接受的答案．这将使别人更容易找到解决方案或帮助回答!
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时联系我有关Smartsheet的帮助，集成，一般的工作流程建议，或其他完全的东西。
-
kdashnaw ✭
@Andree Stara非常感谢您的快速回复和帮助!这个公式现在起作用了!
-
她名叫Stara ✭✭✭✭✭✭
太好了!
你太客气了!
✅记住!我的帖子是否帮助或回答了你的问题或解决了你的问题?请通过以下方式支持社区将其标记为有见地/投票赞成或/和作为可接受的答案．这将使别人更容易找到解决方案或帮助回答!
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时联系我有关Smartsheet的帮助，集成，一般的工作流程建议，或其他完全的东西。
帮助文章资源欧宝体育app官方888
类别
I hope you're well and safe!<\/p>
It doesn't work because it's not in the same range. You're comparing three columns against one. You'd have to calculate them one by one and add them together.<\/p>
Try something like this.<\/p>
=SUMIFS(Diagnostic:Diagnostic, Diagnostic:Diagnostic, 1, [Start Date]:[Start Date], IFERROR(YEAR(@cell), 0) = 2022) + SUMIFS(Disc:Disc, Disc:Disc, 1, [Start Date]:[Start Date], IFERROR(YEAR(@cell), 0) = 2022) + SUMIFS([In Progress]:[In Progress], [In Progress]:[In Progress], 1, [Start Date]:[Start Date], IFERROR(YEAR(@cell), 0) = 2022)<\/p>
Did that work\/help? <\/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","log":{"dateUpdated":"2022-10-26 13:35:36","updateUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T16:39:06+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":96975,"type":"question","name":"How to extract data from one sheet and bring it to another sheet?","excerpt":"How to cross reference a sheet to get the following information? I have a sheet titled \"Change Order Log\" with the following columns. My overall goal was to sum up the \"Approved Change Order Amount\" by category. Example: I used the following formula to come up with the sub-total for the \"Regulatory Submissions\" category.…","categoryID":322,"dateInserted":"2022-10-25T18:55:36+00:00","dateUpdated":null,"dateLastComment":"2022-10-26T17:40:54+00:00","insertUserID":154015,"insertUser":{"userID":154015,"name":"Vane","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Vane","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T17:52:34+00:00","banned":0,"punished":0,"private":true,"label":"✭"},"updateUserID":null,"lastUserID":148574,"lastUser":{"userID":148574,"name":"Ryan Sides","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Sides","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu03N-eM91LppALCfccJ9FAxCZ9_6rqdFYbvOL4lgA=s96-c","dateLastActive":"2022-10-26T18:01:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":21,"score":null,"hot":3333531990,"url":"https:\/\/community.smartsheet.com\/discussion\/96975\/how-to-extract-data-from-one-sheet-and-bring-it-to-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96975\/how-to-extract-data-from-one-sheet-and-bring-it-to-another-sheet","format":"Rich","lastPost":{"discussionID":96975,"commentID":348785,"name":"Re: How to extract data from one sheet and bring it to another sheet?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348785#Comment_348785","dateInserted":"2022-10-26T17:40:54+00:00","insertUserID":148574,"insertUser":{"userID":148574,"name":"Ryan Sides","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Sides","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu03N-eM91LppALCfccJ9FAxCZ9_6rqdFYbvOL4lgA=s96-c","dateLastActive":"2022-10-26T18:01:14+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\/O6VQSHAPSW4G\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-26T16:45:43+00:00","dateAnswered":"2022-10-25T22:02:47+00:00","acceptedAnswers":[{"commentID":348630,"body":" @Vane<\/a> <\/p> Hi Vane, you'll need to create two cross sheet references on your rainbow sheet (right click in any cell and choose \"Manage References\". Hit the create button, navigate to your first sheet, highlight the column \"category\" (make sure to highlight the entire column, not just the cell), name this one \"Categories\" and click the \"insert Reference\" button. Perform the same steps again, this time highlight the Approved Change Order Amount column, name this one \"COs\".<\/p> Now you can use these in a SUMIFS formula similar to the one you created previously. <\/p> =SUMIFS({COs}, {Categories}, HAS(@cell, \"Regulatory Submissions\")<\/p> Please let me know if that works the way you needed.<\/p> -Ryan<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-26 16:45:43","updateUser":{"userID":154015,"name":"Vane","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Vane","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T17:52:34+00:00","banned":0,"punished":0,"private":true,"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":96977,"type":"question","name":"IF Statement with IN list","excerpt":"Column A = Grid Task Status Column B = SCSM Task Status pseudo code: If column A = column B then \"No Action Needed\" If Column A in (\"On Hold\", \"Awaiting External Resources\", \"In Progress\", \"Implementation\", \"Testing) AND Column B = \"In Progress\" then \"No Action Needed\" Otherwise \"Review Needed\"…","categoryID":322,"dateInserted":"2022-10-25T19:01:18+00:00","dateUpdated":null,"dateLastComment":"2022-10-26T13:37:51+00:00","insertUserID":150928,"insertUser":{"userID":150928,"name":"JHuber77","url":"https:\/\/community.smartsheet.com\/profile\/JHuber77","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T13:39:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":148574,"lastUser":{"userID":148574,"name":"Ryan Sides","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Sides","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu03N-eM91LppALCfccJ9FAxCZ9_6rqdFYbvOL4lgA=s96-c","dateLastActive":"2022-10-26T18:01:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":33,"score":null,"hot":3333517749,"url":"https:\/\/community.smartsheet.com\/discussion\/96977\/if-statement-with-in-list","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96977\/if-statement-with-in-list","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":96977,"commentID":348672,"name":"Re: IF Statement with IN list","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348672#Comment_348672","dateInserted":"2022-10-26T13:37:51+00:00","insertUserID":148574,"insertUser":{"userID":148574,"name":"Ryan Sides","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Sides","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu03N-eM91LppALCfccJ9FAxCZ9_6rqdFYbvOL4lgA=s96-c","dateLastActive":"2022-10-26T18:01:14+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-10-26T11:42:04+00:00","dateAnswered":"2022-10-25T20:48:49+00:00","acceptedAnswers":[{"commentID":348620,"body":"
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/H5WYP7QGLYFA\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/BDTX9CX3IB4Y\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
