工作表摘要报表图表

罗斯Novotny
罗斯Novotny ✭✭✭✭✭
编辑03/21/23 在公式和函数

当我尝试创建工作表摘要报告的图表时，我继续得到一个错误。错误提示“所选数据无法绘制图表”。请选择一个新的范围”。数据非常简单，它是一个包含15个位置的列表，完整性在0到100之间。我试图删除我的工作表摘要公式中的百分比，但结果是一样的。有人知道为什么我不能用条形图(或任何图形)来绘制数据吗?

标签:
· 在Facebook上分享 在Twitter上分享

最佳答案

答案

帮助文章参考资料欧宝体育app官方888

在智能表中创建和编辑公式

交叉表引用的公式组合

智能表功能列表

类别

想要直接在智能表中练习使用公式吗?

请查看公式手册模板!
It helps me to break out the formula:<\/p>
\n
\n \n \"code1.PNG\"<\/img><\/a>\n <\/div>\n<\/div>\n

You do not need the \"=\" in {Request - Segment}, =\"WellMed\",<\/p>

I'm not sure what you are trying to do with attempting to add \"Accounts Receivable\" to the result of a nested COUNTIF at the end. Is this a mistake?<\/p>"},{"commentID":379471,"body":"

@Carson Penticuff<\/a> <\/p>

=COUNTIFS({Request - Create Date}, IFERROR(MONTH(@cell), 0) = [WSSM#]@row, {Request - Create Date}, IFERROR(YEAR(@cell), 0) = Year@row, {Request - Segment}, \"WellMed\", {WSS}, \"Accounts Receivable\") + COUNTIFS({Complete Create Date}, IFERROR(MONTH(@cell), 0) = [WSSM#]@row, {Complete Create Date}, IFERROR(YEAR(@cell), 0) = Year@row, {Completed Segment}, \"WellMed\", {Completed - WSS}, \"Accounts Receivable\")<\/p>


<\/p>

All Fixed! :)<\/p>


<\/p>

Thanks!<\/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":106160,"type":"question","name":"Can I copy a row to another sheet more than once?","excerpt":"Is it possible to copy a row to another sheet and have it copy multiple times on sheet #2? For example on sheet #1 I have a project with multiple dates for different deliverables within the overall project. I need these projects to copy over to a 2nd sheet where we get a separate line for each date. Right now we are…","categoryID":322,"dateInserted":"2023-06-07T18:30:50+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T18:54:48+00:00","insertUserID":144831,"insertUser":{"userID":144831,"name":"Alywilk","url":"https:\/\/community.smartsheet.com\/profile\/Alywilk","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!AlHRh1iFOfw!bRdTGyDgT7Q!6cfIEyX8VjJ","dateLastActive":"2023-06-07T19:16:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":162073,"lastUser":{"userID":162073,"name":"Melissa Yamada","title":"Data Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Melissa%20Yamada","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/JBO7YXU6221D\/nLL8MQQWP4C8M.jpeg","dateLastActive":"2023-06-07T20:51:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":27,"score":null,"hot":3372327338,"url":"https:\/\/community.smartsheet.com\/discussion\/106160\/can-i-copy-a-row-to-another-sheet-more-than-once","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106160\/can-i-copy-a-row-to-another-sheet-more-than-once","format":"Rich","tagIDs":[334],"lastPost":{"discussionID":106160,"commentID":379418,"name":"Re: Can I copy a row to another sheet more than once?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379418#Comment_379418","dateInserted":"2023-06-07T18:54:48+00:00","insertUserID":162073,"insertUser":{"userID":162073,"name":"Melissa Yamada","title":"Data Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Melissa%20Yamada","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/JBO7YXU6221D\/nLL8MQQWP4C8M.jpeg","dateLastActive":"2023-06-07T20:51:20+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-07T19:16:21+00:00","dateAnswered":"2023-06-07T18:54:48+00:00","acceptedAnswers":[{"commentID":379418,"body":"

You should be able to do this with the Copy Row workflow automation. Just set a different trigger for the different deliverables so it will get copied more than once<\/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":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":106137,"type":"question","name":"Trying to determine if all children have N\/A Status","excerpt":"I'm working on a formula for summary rows to look at the % Complete of the row as well as the statuses of the child rows. I have the % Complete portion handled: =IF([% Complete]@row = 1, \"Complete\", IF(AND([% Complete]@row > 0, [% Complete]@row < 1), \"In Progress\", IF([% Complete]@row = 0, \"Not Started\"))) I want to add in…","categoryID":322,"dateInserted":"2023-06-07T14:52:30+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T15:16:49+00:00","insertUserID":157541,"insertUser":{"userID":157541,"name":"ro.fei","title":"","url":"https:\/\/community.smartsheet.com\/profile\/ro.fei","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4OWA5DDSR8JB\/n2H4UP1N6TZA6.jpg","dateLastActive":"2023-06-07T17:59:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":157541,"lastUser":{"userID":157541,"name":"ro.fei","title":"","url":"https:\/\/community.smartsheet.com\/profile\/ro.fei","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4OWA5DDSR8JB\/n2H4UP1N6TZA6.jpg","dateLastActive":"2023-06-07T17:59:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":24,"score":null,"hot":3372301159,"url":"https:\/\/community.smartsheet.com\/discussion\/106137\/trying-to-determine-if-all-children-have-n-a-status","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106137\/trying-to-determine-if-all-children-have-n-a-status","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106137,"commentID":379294,"name":"Re: Trying to determine if all children have N\/A Status","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379294#Comment_379294","dateInserted":"2023-06-07T15:16:49+00:00","insertUserID":157541,"insertUser":{"userID":157541,"name":"ro.fei","title":"","url":"https:\/\/community.smartsheet.com\/profile\/ro.fei","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4OWA5DDSR8JB\/n2H4UP1N6TZA6.jpg","dateLastActive":"2023-06-07T17:59:33+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-07T15:16:56+00:00","dateAnswered":"2023-06-07T15:16:49+00:00","acceptedAnswers":[{"commentID":379294,"body":"

I got it! It's long but it works:<\/p>


<\/p>

=IF(AND(CONTAINS(\"N\/A\", CHILDREN(STATUS@row)), CONTAINS(\"Not Started\", CHILDREN(STATUS@row)) = false, CONTAINS(\"In Progress\", CHILDREN(STATUS@row)) = false, CONTAINS(\"Complete\", CHILDREN(STATUS@row)) = false), \"N\/A\", IF([% Complete]@row = 1, \"Complete\", IF(AND([% Complete]@row > 0, [% Complete]@row < 1), \"In Progress\", IF([% Complete]@row = 0, \"Not Started\"))))<\/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"}]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

公式和函数趋势

  • 配方不工作只有5个月

    Hey All， =COUNTIFS({Request - Create Date}， IFERROR(MONTH(@cell)， 0) = [WSSM#]@row， {Request - Create Date}， IFERROR(YEAR(@cell)， 0) = Year@row， {Request - Segment}， ="WellMed"， {WSS}， ="Accounts Receivable" + COUNTIFS({Complete Create Date}， IFERROR(MONTH(@cell)， 0) = [WSSM#]@row， {Complete Create Date}，…

  • 我可以将一行复制到另一个工作表多次吗?

    是否有可能将一行复制到另一张工作表，并在工作表#2上复制多次?例如，在表格1中，我有一个项目，在整个项目中，不同的可交付成果有多个日期。我需要这些项目复制到第二页，我们得到一个单独的行每个日期。现在我们……

  • 试图确定是否所有子节点都具有“N/A状态”

    我正在研究汇总行的公式，以查看行的% Complete以及子行的状态。我有%完成部分处理:=IF([% Complete]@row = 1，“完成”，如果(AND([% Complete]@row > 0， [% Complete]@row < 1)，“正在进行中”，如果([% Complete]@row = 0，“未开始”)))我想添加…