一行数字
你好,
我已经看到了关于这个的多个线程，但我仍然惊讶于没有动态解决方案，我已经尝试通过AutoNumber列自动填充ROWID，正如你在截图中看到的，每当我试图添加一个新行之间，它会从底部计算行号(哇)，这是非常糟糕的，这导致我的通知发送错误。
我尝试=RowID1 + 1自动填充行ID，但当我在两行之间插入新行时，它不起作用。
是否有任何公式可以帮助自动填充行id ?即使我们在两行之间插入新行?
最佳答案
答案
-
Amit Wadhwani ✭✭✭✭✭
太棒了，保罗!!
非常感谢!
-
保罗新来的 ✭✭✭✭✭✭ -
Mehran Bagherian ✭✭✭✭✭
嗨,保罗,
你能解释一下这个公式吗?它是如何工作的呢?
我不能用它。这对我没用。
-
保罗新来的 ✭✭✭✭✭✭
-
Mehran Bagherian ✭✭✭✭✭
-
Mehran Bagherian ✭✭✭✭✭
保罗,
我解出来了。我只是用另一列代替“任务名称”。我想知道为什么它对那个专栏不起作用!!
谢谢你！
-
保罗新来的 ✭✭✭✭✭✭
@Sterling克劳福德是的。拥有使用列公式的能力当然会使事情变得更加简单和可靠。
我已经从以前的方法(列前公式)切换到在指向自动编号的文本/数字列中使用自动编号列和MATCH函数。
thinkspi.com
-
尼尔·米 ✭
-
@Paul新来的帮了大忙，谢谢。
-
@Paul新来的——嗨,
希望您能帮助调整下面的公式，使其在选择“关闭”时不包括行。实际上只计算选择了“打开”或“积压”的行。
1美元=条件统计((项目名称):【项目名称】@row,或(@cell = " ", @cell < > " "))
帮助文章资源欧宝体育app官方888
类别
- Automate Health aggregation one level higher (i.e., Project Name).<\/li>
- Automate Health for Milestones without nested Tasks to act as if they were Child rows.<\/li>
- Automate Health for Tasks with Sub-Tasks to act as if they were Parent rows.<\/li><\/ul>
Completed Formula:<\/strong><\/p>
=IF(AND(OR(Project@row = 1, Component@row = 1, Milestone@row = 1), COUNT(CHILDREN()) > 0), (IF(COUNTIF(CHILDREN(), \"Blue\") = COUNT(CHILDREN()), \"Blue\", IF(COUNTIF(CHILDREN(), \"Red\") > 0, \"Red\", IF(AND(COUNTIF(CHILDREN(), \"Yellow\") > 0, COUNTIF(CHILDREN(), \"Yellow\") >= COUNTIF(CHILDREN(), \"Green\")), \"Yellow\", \"Green\")))), (IF(COUNT(CHILDREN()) > 0, (IF(COUNTIF(CHILDREN(), \"Blue\") = COUNT(CHILDREN()), \"Blue\", IF(COUNTIF(CHILDREN(), \"Red\") > 0, \"Red\", IF(AND(COUNTIF(CHILDREN(), \"Yellow\") > 0, COUNTIF(CHILDREN(), \"Yellow\") >= COUNTIF(CHILDREN(), \"Green\")), \"Yellow\", \"Green\")))), (IF(OR(Status@row = \"Complete\", Status@row = \"Descoped\"), \"Blue\", IF(Status@row = \"At Risk\", \"Red\", IF(AND(Status@row = \"//www.santa-greenland.com/community/discussion/69476/\", TODAY() < [End Date]@row), \"Yellow\", IF(AND(Status@row = \"//www.santa-greenland.com/community/discussion/69476/\", TODAY() >= [End Date]@row), \"Red\", IF(AND(Status@row = \"Not Started\", TODAY() >= [End Date]@row), \"Red\", IF(AND(Status@row = \"In Progress\", TODAY() >= [End Date]@row), \"Red\", IF(AND(Status@row = \"Requires Review\", TODAY() >= [End Date]@row), \"Red\", IF(AND(Status@row = \"In Progress\", TODAY() < [End Date]@row), \"Green\", IF(AND(Status@row = \"Not Started\", TODAY() < [Start Date]@row, Duration@row <= 10), \"Green\", IF(AND(Status@row = \"Not Started\", TODAY() < [Start Date]@row, Duration@row > 10), \"Green\", IF(AND(Status@row = \"Not Started\", [End Date]@row > TODAY(), TODAY() >= [Start Date]@row, Duration@row <= 10), \"Yellow\", IF(AND(Status@row = \"Not Started\", [End Date]@row > TODAY(), TODAY() >= [Start Date]@row, Duration@row > 10), \"Green\", IF(AND(Status@row = \"Requires Review\", TODAY() < [Start Date]@row, Duration@row <= 10), \"Yellow\", IF(AND(Status@row = \"Requires Review\", TODAY() < [Start Date]@row, Duration@row > 10), \"Yellow\", IF(AND(Status@row = \"Requires Review\", [End Date]@row > TODAY(), TODAY() >= [Start Date]@row, Duration@row <= 10), \"Red\", IF(AND(Status@row = \"Requires Review\", [End Date]@row > TODAY(), TODAY() >= [Start Date]@row, Duration@row > 10), \"Yellow\"))))))))))))))))))))<\/p>
Columns Required:<\/strong><\/p>
- Column Name = Project \/\/ Column Type = Checkbox<\/li>
- Column Name = Component \/\/ Column Type = Checkbox<\/li>
- Column Name = Milestone \/\/ Column Type = Checkbox<\/li>
- Column Name = Health \/\/ Column Type = Symbols (4 Colors for Red, Green, Yellow, & Blue)<\/li>
- Column Name = Status \/\/ Column Type = Dropdown List (6 Statuses for \"Blank,\" \"Not Started,\" \"In Progress,\" \"Requires Review,\" \"At Risk,\" \"Completed,\" & \"Descoped\")<\/li>
- Column Name = Start Date \/\/ Column Type = Date\/Time<\/li>
- Column Name = End Date \/\/ Column Type = Date\/Time<\/li>
- Column Name = Duration \/\/ Column Type = Duration<\/li><\/ul>"}]}},"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":104029,"type":"question","name":"Need help on a formula that adds the totals for individual names?","excerpt":"Hi, I wanted to create a table (similar to the example below) that adds total scores for individual names in new columns. Just wondering if it is possible? If so, what formula can I use? much appreciate if someone could please help. ","categoryID":322,"dateInserted":"2023-04-14T13:56:10+00:00","dateUpdated":null,"dateLastComment":"2023-04-14T16:33:32+00:00","insertUserID":159253,"insertUser":{"userID":159253,"name":"ovelzone","url":"https:\/\/community.smartsheet.com\/profile\/ovelzone","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-15T18:53:27+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-04-15T17:25:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":47,"score":null,"hot":3362973582,"url":"https:\/\/community.smartsheet.com\/discussion\/104029\/need-help-on-a-formula-that-adds-the-totals-for-individual-names","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104029\/need-help-on-a-formula-that-adds-the-totals-for-individual-names","format":"Rich","lastPost":{"discussionID":104029,"commentID":371831,"name":"Re: Need help on a formula that adds the totals for individual names?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/371831#Comment_371831","dateInserted":"2023-04-14T16:33:32+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-04-15T17:25:58+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\/T3AJVJWS9MK6\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-04-14T19:15:06+00:00","dateAnswered":"2023-04-14T14:31:34+00:00","acceptedAnswers":[{"commentID":371800,"body":"
Hi @ovelzone<\/a> <\/p>
I hope you're well and safe!<\/p>
Have you explored using a Report instead?<\/p>
Would that work\/help? <\/p>
I hope that helps!<\/p>
Be safe, and have a fantastic weekend!<\/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>"},{"commentID":371801,"body":"
Hello @ovelzone<\/a> - Give this a try.<\/p>
=SUMIF(Name:Name, Names@row, Scores:Scores)<\/code><\/p>I hope that helps!<\/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":104028,"type":"question","name":"IF Then [Incorrect Argument] Question.","excerpt":"Please assist with this formula: =IF(Status@row, \"Fully Approved\", [Signing Status]@row, \"Sent\", NETDAYS([Fully Approved Date]@row + 1)) In this case the bold portion is my THEN calculation.","categoryID":322,"dateInserted":"2023-04-14T13:00:30+00:00","dateUpdated":null,"dateLastComment":"2023-04-14T14:13:09+00:00","insertUserID":148602,"insertUser":{"userID":148602,"name":"Mike B","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/AT4NBT0RCEB5\/nMYTT0CUGWMWH.jpg","dateLastActive":"2023-04-14T14:11:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":148602,"lastUser":{"userID":148602,"name":"Mike B","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/AT4NBT0RCEB5\/nMYTT0CUGWMWH.jpg","dateLastActive":"2023-04-14T14:11:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":38,"score":null,"hot":3362963019,"url":"https:\/\/community.smartsheet.com\/discussion\/104028\/if-then-incorrect-argument-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104028\/if-then-incorrect-argument-question","format":"Rich","lastPost":{"discussionID":104028,"commentID":371797,"name":"Re: IF Then [Incorrect Argument] Question.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/371797#Comment_371797","dateInserted":"2023-04-14T14:13:09+00:00","insertUserID":148602,"insertUser":{"userID":148602,"name":"Mike B","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/AT4NBT0RCEB5\/nMYTT0CUGWMWH.jpg","dateLastActive":"2023-04-14T14:11:27+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-04-14T14:13:25+00:00","dateAnswered":"2023-04-14T14:04:45+00:00","acceptedAnswers":[{"commentID":371793,"body":"
