混合报告/shet

JeffG
JeffG ✭
12/09/19编辑 内公式函数

智能表跟踪多项目性能

快速收集任务列表并比较完成日期

但我无法加列列配有公式显示图形基础分配是否按时完成或多行(即配公式计算按时完成任务百分比

单页上可以做到这一点,然后将列列载入报告,但性能度量则公有领域而非私有领域

当前我将报表导出Excel手动跟踪性能

智能表内部有方法实现这一点而不广泛提供性能度量码吗?if not,请考虑添加此功能

标签 :
· 分享脸书 分享Twitter

注释

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

创建并编辑智能表公式

公式组合跨表引用

智能表函数列表

类别分类

直接用Smartshe

查查 公式手册模板
found out myself you actually have to search so type in the sheet you want press enter and the sheet will come up<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","description":"Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":["discussion","question"]},"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":115139,"type":"question","name":"Percentage in a formula","excerpt":"Hi, Happy New Year!坚持我所想的简单公式 我希望你能帮助我RYG球有三个不同的阈值:3%以上-红色0-3%-黄下0-绿色我公式如下:坚持我所想的简单公式 我希望你能帮助我We have three different thresholds that I need to use to change the RYG…","categoryID":322,"dateInserted":"2024-01-05T10:32:12+00:00","dateUpdated":null,"dateLastComment":"2024-01-05T12:53:50+00:00","insertUserID":158375,"insertUser":{"userID":158375,"name":"angelapaj","url":"https:\/\/community.smartsheet.com\/profile\/angelapaj","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5BAYC7LUN4FS\/nVF87K3DDO2KL.jpg","dateLastActive":"2024-01-05T13:31:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":158375,"lastUser":{"userID":158375,"name":"angelapaj","url":"https:\/\/community.smartsheet.com\/profile\/angelapaj","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5BAYC7LUN4FS\/nVF87K3DDO2KL.jpg","dateLastActive":"2024-01-05T13:31:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":19,"score":null,"hot":3408911162,"url":"https:\/\/community.smartsheet.com\/discussion\/115139\/percentage-in-a-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/115139\/percentage-in-a-formula","format":"Rich","lastPost":{"discussionID":115139,"commentID":411984,"name":"Re: Percentage in a formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/411984#Comment_411984","dateInserted":"2024-01-05T12:53:50+00:00","insertUserID":158375,"insertUser":{"userID":158375,"name":"angelapaj","url":"https:\/\/community.smartsheet.com\/profile\/angelapaj","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5BAYC7LUN4FS\/nVF87K3DDO2KL.jpg","dateLastActive":"2024-01-05T13:31:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2024-01-05T12:53:30+00:00","dateAnswered":"2024-01-05T12:31:56+00:00","acceptedAnswers":[{"commentID":411979,"body":"

angelapaj/a

3%为03尝试修改公式至++/p

IF(lippage@row/0/Green/

欢呼 ++/p

John<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","description":"Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":["discussion","question"]},"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":115111,"type":"question","name":"Formula to add leading 'zero' to IDs","excerpt":"I have used these formulas individually and they work, but need to combine as an OR statement =IF(LEN(MSID@row) = 2, \"00\" + MSID@row, MSID@row) =IF(LEN(MSID@row) = 3, \"0\" + MSID@row, MSID@row) =IF(OR(IF(LEN(MSID@row) = 2, \"00\" + MSID@row, MSID@row), LEN(MSID@row) = 3, \"0\" + MSID@row, MSID@row)) But the combined formula…","snippet":"I have used these formulas individually and they work, but need to combine as an OR statement =IF(LEN(MSID@row) = 2, \"00\" + MSID@row, MSID@row) =IF(LEN(MSID@row) = 3, \"0\" +…","categoryID":322,"dateInserted":"2024-01-04T18:50:17+00:00","dateUpdated":null,"dateLastComment":"2024-01-05T05:54:50+00:00","insertUserID":166322,"insertUser":{"userID":166322,"name":"Kevin7859","title":"Program Specialist IV","url":"https:\/\/community.smartsheet.com\/profile\/Kevin7859","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2024-01-05T13:12:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":163268,"lastUser":{"userID":163268,"name":"Anjanesh Vaidya","url":"https:\/\/community.smartsheet.com\/profile\/Anjanesh%20Vaidya","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/U1BXZY7D06P9\/n1ZMEG6YK4PSK.PNG","dateLastActive":"2024-01-05T07:04:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":19,"score":null,"hot":3408828907,"url":"https:\/\/community.smartsheet.com\/discussion\/115111\/formula-to-add-leading-zero-to-ids","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/115111\/formula-to-add-leading-zero-to-ids","format":"Rich","lastPost":{"discussionID":115111,"commentID":411953,"name":"Re: Formula to add leading 'zero' to IDs","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/411953#Comment_411953","dateInserted":"2024-01-05T05:54:50+00:00","insertUserID":163268,"insertUser":{"userID":163268,"name":"Anjanesh Vaidya","url":"https:\/\/community.smartsheet.com\/profile\/Anjanesh%20Vaidya","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/U1BXZY7D06P9\/n1ZMEG6YK4PSK.PNG","dateLastActive":"2024-01-05T07:04:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2024-01-05T13:12:49+00:00","dateAnswered":"2024-01-05T05:54:50+00:00","acceptedAnswers":[{"commentID":411953,"body":"

HiKevin7859<\/strong><\/a>,<\/p>

可试下方公式合并提及条件.++/p

IFLEN(MSID@row)=2,\"00\"+MSID@IFLEN(MSID@row)=3,\"0\"+MSID@row

/p

Thank you!++/p

Anjanesh Vaidya<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","description":"Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":["discussion","question"]},"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=322&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":10000,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

公式函数趋势
  • 自动化问题

    创建新表传递信息,但当我去搭建自动化并选择表空或帮助

  • 百分比公式

    新年快乐坚持我所想的简单公式 我希望你能帮助我3个不同的阈值需要我改变RYG球量 : 3%以上- 红色0-3%- 黄底0-绿色我公式如下: =IF(ISBLANK(Slippage@row)), ",IF(Slippage@row>0.3

  • 公式添加前导'0'到ID

    单方使用这些公式并有效,但需要合并为OR语句2,OID@row