欢迎访问智能表论坛归档


本论坛文章不再监控精度,内容可能不再现时或创建更多当前版本 访问当前论坛

关键路径

Mark Rockwood公司
Mark Rockwood公司 ✭
12/09/19编辑 内存档2015邮箱

智能表是否有能力计算并显示gant关键路径,如微软项目关键路径分析

标签 :
· 分享脸书 分享Twitter

注释

讨论结束

类别分类

范围大小匹配/p>

庆典1<\/strong>:Celebrationsservice++/p

后你也需要++/p

[month值1<\/strong>:[Month Value]@row<\/strong><\/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":113971,"type":"question","name":"Applying same conditional format per column","excerpt":"Hello.尝试快速出勤跟踪会议条件格式化修改单元格颜色不过我似乎无法想方设法逐列多列应用规则需要一种方法拷贝第三列 并应用到所有尝试快速出勤跟踪会议条件格式化修改单元格颜色However I cannot seem to find…","categoryID":321,"dateInserted":"2023-12-06T15:48:55+00:00","dateUpdated":"2023-12-07T00:03:47+00:00","dateLastComment":"2023-12-07T15:05:47+00:00","insertUserID":171521,"insertUser":{"userID":171521,"name":"Brad Tippett","url":"https:\/\/community.smartsheet.com\/profile\/Brad%20Tippett","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-12-07T15:03:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":166028,"lastUserID":171521,"lastUser":{"userID":171521,"name":"Brad Tippett","url":"https:\/\/community.smartsheet.com\/profile\/Brad%20Tippett","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-12-07T15:03:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":31,"score":null,"hot":3403840482,"url":"https:\/\/community.smartsheet.com\/discussion\/113971\/applying-same-conditional-format-per-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/113971\/applying-same-conditional-format-per-column","format":"Rich","lastPost":{"discussionID":113971,"commentID":408406,"name":"Re: Applying same conditional format per column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/408406#Comment_408406","dateInserted":"2023-12-07T15:05:47+00:00","insertUserID":171521,"insertUser":{"userID":171521,"name":"Brad Tippett","url":"https:\/\/community.smartsheet.com\/profile\/Brad%20Tippett","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-12-07T15:03:39+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/ZOKM75I51431\/cf-rules.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/ZOKM75I51431\/cf-rules.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/ZOKM75I51431\/cf-rules.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/ZOKM75I51431\/cf-rules.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/ZOKM75I51431\/cf-rules.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/ZOKM75I51431\/cf-rules.png"},"alt":"CF Rules.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-12-07T13:23:17+00:00","dateAnswered":"2023-12-06T16:19:38+00:00","acceptedAnswers":[{"commentID":408220,"body":"

HI-我想知道你是否会考虑 以不同方式看待问题i'm新手,所以这就是我如何接近它- 基本允许你为网格上的每一列创建少数规则而不是新规则

重构你表++/强使用/强解决基础-基本像下截图

使用表单输入数据时,可使用复选框表示dept是否参会日期列格式化\\"创建日期\"显示表输入数据时,

汉城
汉城 汉城图像.png/IMG++++++++++++++++++

并使用条件格式检查时将BG颜色改为绿色简单\"crone规则\"并修改列ID匹配
汉城
汉城 汉城图像.png/IMG++++++++++++++++++
汉城
汉城 汉城图像.png/IMG++++++++++++++++++


/p

表格将自动记录创建日期,您可以在每日/周会中选择复选框,同时选择窗体设置和逻辑区的其他酷点.+++/p
汉城
汉城 汉城图像.png/IMG++++++++++++++++++

s测试表时,不要忘记屏幕右顶端的gopen表单

Hope this helps, good luck!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","description":"Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":113956,"type":"question","name":"Number of Dates in a Column","excerpt":"I'm looking for a simple formula to count dates contained with a month and year.日期格式设置为 01\11\2023unitifs({stratedDate}date:Date/MONETH(@Cell)=11The date format is set up as such: 01\/11\/2023 I've read plenty of advice on this one but I cant…","categoryID":322,"dateInserted":"2023-12-06T08:59:12+00:00","dateUpdated":null,"dateLastComment":"2023-12-07T14:34:13+00:00","insertUserID":170632,"insertUser":{"userID":170632,"name":"Ed Gadd","title":"Ed","url":"https:\/\/community.smartsheet.com\/profile\/Ed%20Gadd","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2fkmPhvALio!packadPatDo!JtI7NoOie9d","dateLastActive":"2023-12-07T10:17:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-12-07T14:59:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":32,"score":null,"hot":3403814605,"url":"https:\/\/community.smartsheet.com\/discussion\/113956\/number-of-dates-in-a-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/113956\/number-of-dates-in-a-column","format":"Rich","lastPost":{"discussionID":113956,"commentID":408394,"name":"Re: Number of Dates in a Column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/408394#Comment_408394","dateInserted":"2023-12-07T14:34:13+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-12-07T14:59:04+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":"2023-12-07T11:52:39+00:00","dateAnswered":"2023-12-06T15:01:59+00:00","acceptedAnswers":[{"commentID":408197,"body":"

语法多取/p

=COUNTIFS({START DATE}, AND(IFERROR(MONTH(@cell), 0) = 11, IFERROR(YEAR(@cell), 0) = 2022))<\/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&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&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 Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

趋势化邮箱

  • SUMIF计数当前行的可能性

    哈罗尝试编译公式计数到列内当前行sUMIF([月值]:[月值]/MONTH/Date@row/Celebracations/Callbrations/不过,我要总和

  • 单列应用相同的条件格式

    哈罗尝试快速出勤跟踪会议条件格式化修改单元格颜色不过我似乎无法想方设法逐列多列应用规则需要一种方法拷贝列3 并应用到所有

  • 列内日期数

    我寻找简单公式计算日期 内含月年日期格式设置为:01/11/2023at=COUNTIFS({STARTDATE},日期:DateMONTH(@Cell)=11