如何设置一个工作流，以便在前一个任务完成时通知某人?
格雷森Gammill
✭✭
我目前正试图开发一个项目计划表，我希望能够通知某人当前任任务完成，让他们知道他们可以开始工作。
例如，如果John必须执行数据源识别和验证，但在Mark转换和清理数据之前他无法执行该操作，我希望能够在Mark将转换和数据清理行标记为完成时自动通知John。我该怎么做呢?
答案
-
希瑟·达夫 ✭✭✭✭✭✭你好,格雷森!这个话题好像在社区里出现过几次。这里有一个:
-
希瑟·达夫 ✭✭✭✭✭✭
我当然希望有更简单的方法，但我不确定是否有。我要稍微摆弄一下，看看能不能想出一个替代方案。
谢谢,
希瑟
-
最小值 ✭
我知道自从这个问题发布以来已经一年多了，但我最近发现了一个更简单的方法，对我的团队有效。
我们没有尝试建立一个复杂的公式，而是在“任务责任”列旁边添加了一个“继任者责任”列。然后在“继任者责任”一栏中，我们分配负责继任者任务的人员的姓名。这样做允许我们让WorkFlow通知负责下一个任务的人员，而不是负责当前任务的人员。
作为视觉参考:
希望这对你有帮助!
类别
@Frank B.<\/a> If the folders are in the same Workspace that the sheets currently reside, there will for sure be no impact.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":371,"urlcode":"WorkApps","name":"WorkApps"},{"tagID":443,"urlcode":"dynamic-view","name":"Dynamic View"}]},{"discussionID":106272,"type":"question","name":"Automation to send past due notifications to members","excerpt":"Hi All! I hope someone can help me create a (functioning!) automation. I need Smarsheets to send a daily notification to task owners, if the task is marked past due. Currently, I have been able to create an automation that will alert owners when a task becomes past due; however, this is a one-time notification. I've…","categoryID":321,"dateInserted":"2023-06-09T14:40:21+00:00","dateUpdated":"2023-06-09T14:48:10+00:00","dateLastComment":"2023-06-09T15:01:14+00:00","insertUserID":162249,"insertUser":{"userID":162249,"name":"blake_smith_b","title":"Accountant - Financial Reporting","url":"https:\/\/community.smartsheet.com\/profile\/blake_smith_b","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T15:10:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":142964,"lastUser":{"userID":142964,"name":"Ray Lindstrom","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20Lindstrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5Y0KP6UKIBTU\/nY3615V0DPRZV.jpg","dateLastActive":"2023-06-09T16:08:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":null,"hot":3372645095,"url":"https:\/\/community.smartsheet.com\/discussion\/106272\/automation-to-send-past-due-notifications-to-members","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106272\/automation-to-send-past-due-notifications-to-members","format":"Rich","tagIDs":[334,510],"lastPost":{"discussionID":106272,"commentID":379850,"name":"Re: Automation to send past due notifications to members","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379850#Comment_379850","dateInserted":"2023-06-09T15:01:14+00:00","insertUserID":142964,"insertUser":{"userID":142964,"name":"Ray Lindstrom","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20Lindstrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5Y0KP6UKIBTU\/nY3615V0DPRZV.jpg","dateLastActive":"2023-06-09T16:08:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"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\/XJX8FMEG7M9C\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T15:12:48+00:00","dateAnswered":"2023-06-09T15:01:14+00:00","acceptedAnswers":[{"commentID":379850,"body":"
In the Trigger section, select \"When a date is reached\",<\/p>
Then select \"Custom\" for when to run the automation, and select \"Repeat Every\" and choose 1 Day.<\/p>
Then select your Conditions. For yours, you can say \"Where Past Due?\", and select \"is one of\", then choose \"Past Due\"<\/p>
Example below.<\/p>
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/QXUWT54UPHSR\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/TJSUPMDMX8IX\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![https:\/\/us.v-cdn.net\/6031209\/uploads\/NP86T060BMPE\/image.png<\/a><\/p>Column 1<\/strong>: Row ID<\/p>=COUNTIFS([Task Name]$1:[Task Name]@row, OR(@cell = "", @cell <> ""))<\/p>In this example, I have referenced the [Task Name] column, but any column can be used. I stole this formula from another post thanks to Paul Newcome. This formula works regardless of how you move, copy, paste rows. The only downside is that it can’t be a column formula. https:\/\/community.smartsheet.com\/discussion\/69476\/row-numbers<\/a> <\/p>Column 2<\/strong>: Row ID Comma<\/p>=", " + [Row ID]@row + ","<\/p>This column is the column that will actually be looked up by the counting formula. The commas are needed to avoid false positive matches (e.g. prevent finding “2” in “20”, looking up “, 2,” won’t be found in “, 20,”<\/p>Column 3<\/strong>: Pred Replace FS<\/p>=", " + SUBSTITUTE(Predecessors@row, "FS", ",") + ","<\/p>This formula adds the needed commas at the beginning and end of Predecessor column, as well as changing “FS” into a comma (needed to ensure a FS predecessor with a lag will still work). Modify this formula with more nested substitute formulas to make it work with other predecessor types (FF, SS, SF) as you desire.<\/p>Column 4<\/strong>: Pred Count<\/p>=COUNT(COLLECT([Row ID Comma]:[Row ID Comma], [Row ID Comma]:[Row ID Comma], AND(NOT(ISBLANK(@cell)), FIND(@cell, [Pred Replace FS]@row) > 0)))<\/p>This formula counts the number of rows where the [Row ID Comma] (looks at every row) is found inside the [Pred Replace FS] column (current row only).<\/p>Column 5<\/strong>: Pred Done Count<\/p>=COUNT(COLLECT([Row ID Comma]:[Row ID Comma], [Row ID Comma]:[Row ID Comma], AND(NOT(ISBLANK(@cell)), FIND(@cell, [Pred Replace FS]@row) > 0), [% Complete]:[% Complete], 1))<\/p>This is similar to the [Pred Count] column, except it adds an additional condition: the % Complete column must also equal 100%. This condition can be changed to point at a different column (e.g. check box column, Status column, etc.).<\/p>Column 6<\/strong>: Ready Status<\/p>=IF([Pred Done Count]@row = [Pred Count]@row, "Ready", "Waiting")<\/p>This column compares the [Pred Count] column and the [Pred Done Count] column. If the counts match, then all the predecessors are finished.<\/p> <\/p>2 Column Solution:<\/p>https:\/\/us.v-cdn.net\/6031209\/uploads\/V3XQ7GBX5FMB\/image.png<\/a><\/p>Column 1<\/strong>: One Formula Row ID<\/p>=", " + COUNTIFS([Task Name]$1:[Task Name]@row, OR(@cell = "", @cell <> "")) + ","<\/p>I combined [Row ID] and [Row ID Comma] into a single formula. This cannot be a column formula.<\/p>Column 2<\/strong>: One Formula Ready Status<\/p>=IF(COUNT(COLLECT([Row ID Comma]:[Row ID Comma], [Row ID Comma]:[Row ID Comma], AND(NOT(ISBLANK(@cell)), FIND(@cell, ", " + SUBSTITUTE(Predecessors@row, "FS", ",") + ",") > 0), [% Complete]:[% Complete], 1)) = COUNT(COLLECT([Row ID Comma]:[Row ID Comma], [Row ID Comma]:[Row ID Comma], AND(NOT(ISBLANK(@cell)), FIND(@cell, ", " + SUBSTITUTE(Predecessors@row, "FS", ",") + ",") > 0))), "Ready", "Waiting")<\/p>I combined [Pred Replace FS], [Pred Count], [Pred Done Count], and [Ready Status] into a single formula. This can be converted to a column formula.<\/p>","bodyRaw":"[{\"insert\":\"I have seen many posts about people wanting the ability to indicate a particular task\\\/row is ready to begin because all of the predecessors are complete (many of them archived). All of the proposed solutions had short comings (e.g. only works on rows with a single FS predecessor with no lag). Here is my full solution to the problem.\\nNote 1: I have not tested this extensively. It may not perform well on large sheets.\\nNote 2: In this example, I have chosen for this to only work with FS predecessors (because that’s what makes sense to me). However, I indicate below which formula to change so that this can work with any predecessor type.\\nThis\\nsolution can be done by adding a minimum of 2 columns to your existing sheet,\\nbut I'm going to layout this explanation using 6 columns for ease of following.\\nI will provide the 2 column solution at the end.\\nHere\\nare the 6 column names I used: Row ID, Row ID Comma, Pred Replace FS, Pred\\nCount, Pred Done Count, and Ready Status\\nThe green columns can be converted to column formulas. Unfortunately, I don’t know of a way to get a reliable row ID column using a column formula.\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/NP86T060BMPE\\\/image.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/NP86T060BMPE\\\/image.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Column 1\"},{\"insert\":\": Row ID\\n=COUNTIFS([Task Name]$1:[Task Name]@row, OR(@cell = \\\"\\\", @cell <> \\\"\\\"))\\nIn this example, I have referenced the [Task Name] column, but any column can be used. I stole this formula from another post thanks to Paul Newcome. This formula works regardless of how you move, copy, paste rows. The only downside is that it can’t be a column formula. \"},{\"attributes\":{\"link\":\"https:\\\/\\\/community.smartsheet.com\\\/discussion\\\/69476\\\/row-numbers\"},\"insert\":\"https:\\\/\\\/community.smartsheet.com\\\/discussion\\\/69476\\\/row-numbers\"},{\"insert\":\" \\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Column 2\"},{\"insert\":\": Row ID Comma\\n=\\\", \\\" + [Row ID]@row + \\\",\\\"\\nThis column is the column that will actually be looked up by the counting formula. The commas are needed to avoid false positive matches (e.g. prevent finding “2” in “20”, looking up “, 2,” won’t be found in “, 20,”\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Column 3\"},{\"insert\":\": Pred Replace FS\\n=\\\", \\\" + SUBSTITUTE(Predecessors@row, \\\"FS\\\", \\\",\\\") + \\\",\\\"\\nThis formula adds the needed commas at the beginning and end of Predecessor column, as well as changing “FS” into a comma (needed to ensure a FS predecessor with a lag will still work). Modify this formula with more nested substitute formulas to make it work with other predecessor types (FF, SS, SF) as you desire.\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Column 4\"},{\"insert\":\": Pred Count\\n=COUNT(COLLECT([Row ID Comma]:[Row ID Comma], [Row ID Comma]:[Row ID Comma], AND(NOT(ISBLANK(@cell)), FIND(@cell, [Pred Replace FS]@row) > 0)))\\nThis formula counts the number of rows where the [Row ID Comma] (looks at every row) is found inside the [Pred Replace FS] column (current row only).\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Column 5\"},{\"insert\":\": Pred Done Count\\n=COUNT(COLLECT([Row ID Comma]:[Row ID Comma], [Row ID Comma]:[Row ID Comma], AND(NOT(ISBLANK(@cell)), FIND(@cell, [Pred Replace FS]@row) > 0), [% Complete]:[% Complete], 1))\\nThis is similar to the [Pred Count] column, except it adds an additional condition: the % Complete column must also equal 100%. This condition can be changed to point at a different column (e.g. check box column, Status column, etc.).\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Column 6\"},{\"insert\":\": Ready Status\\n=IF([Pred Done Count]@row = [Pred Count]@row, \\\"Ready\\\", \\\"Waiting\\\")\\nThis column compares the [Pred Count] column and the [Pred Done Count] column. If the counts match, then all the predecessors are finished.\\n \\n2 Column Solution:\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/V3XQ7GBX5FMB\\\/image.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/V3XQ7GBX5FMB\\\/image.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Column 1\"},{\"insert\":\": One Formula Row ID\\n=\\\", \\\" + COUNTIFS([Task Name]$1:[Task Name]@row, OR(@cell = \\\"\\\", @cell <> \\\"\\\")) + \\\",\\\"\\nI combined [Row ID] and [Row ID Comma] into a single formula. This cannot be a column formula.\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Column 2\"},{\"insert\":\": One Formula Ready Status\\n=IF(COUNT(COLLECT([Row ID Comma]:[Row ID Comma], [Row ID Comma]:[Row ID Comma], AND(NOT(ISBLANK(@cell)), FIND(@cell, \\\", \\\" + SUBSTITUTE(Predecessors@row, \\\"FS\\\", \\\",\\\") + \\\",\\\") > 0), [% Complete]:[% Complete], 1)) = COUNT(COLLECT([Row ID Comma]:[Row ID Comma], [Row ID Comma]:[Row ID Comma], AND(NOT(ISBLANK(@cell)), FIND(@cell, \\\", \\\" + SUBSTITUTE(Predecessors@row, \\\"FS\\\", \\\",\\\") + \\\",\\\") > 0))), \\\"Ready\\\", \\\"Waiting\\\")\\nI combined [Pred Replace FS], [Pred Count], [Pred Done Count], and [Ready Status] into a single formula. This can be converted to a column formula.\\n\"}]","format":"rich","dateInserted":"2021-02-02T03:49:23+00:00","insertUser":{"userID":41811,"name":"Tanner Polzin","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Tanner%20Polzin","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!mojB347RWzQ!m6PAXzrhZH4!e2RDlECnGcR","dateLastActive":"2022-11-01T17:14:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/75593\/formula-to-indicate-a-task-is-ready-because-predecessors-are-complete-solution","embedType":"quote","name":"Formula To Indicate A Task Is Ready Because Predecessors Are Complete [Solution]"}"> https://community.smartsheet.com/discussion/75593/formula-to-indicate-a-task-is-ready-because-predecessors-are-complete-solution](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/NP86T060BMPE\/image.png\"){kind=link}
![https:\/\/us.v-cdn.net\/6031209\/uploads\/V3XQ7GBX5FMB\/image.png<\/a><\/p>Column 1<\/strong>: One Formula Row ID<\/p>=", " + COUNTIFS([Task Name]$1:[Task Name]@row, OR(@cell = "", @cell <> "")) + ","<\/p>I combined [Row ID] and [Row ID Comma] into a single formula. This cannot be a column formula.<\/p>Column 2<\/strong>: One Formula Ready Status<\/p>=IF(COUNT(COLLECT([Row ID Comma]:[Row ID Comma], [Row ID Comma]:[Row ID Comma], AND(NOT(ISBLANK(@cell)), FIND(@cell, ", " + SUBSTITUTE(Predecessors@row, "FS", ",") + ",") > 0), [% Complete]:[% Complete], 1)) = COUNT(COLLECT([Row ID Comma]:[Row ID Comma], [Row ID Comma]:[Row ID Comma], AND(NOT(ISBLANK(@cell)), FIND(@cell, ", " + SUBSTITUTE(Predecessors@row, "FS", ",") + ",") > 0))), "Ready", "Waiting")<\/p>I combined [Pred Replace FS], [Pred Count], [Pred Done Count], and [Ready Status] into a single formula. This can be converted to a column formula.<\/p>","bodyRaw":"[{\"insert\":\"I have seen many posts about people wanting the ability to indicate a particular task\\\/row is ready to begin because all of the predecessors are complete (many of them archived). All of the proposed solutions had short comings (e.g. only works on rows with a single FS predecessor with no lag). Here is my full solution to the problem.\\nNote 1: I have not tested this extensively. It may not perform well on large sheets.\\nNote 2: In this example, I have chosen for this to only work with FS predecessors (because that’s what makes sense to me). However, I indicate below which formula to change so that this can work with any predecessor type.\\nThis\\nsolution can be done by adding a minimum of 2 columns to your existing sheet,\\nbut I'm going to layout this explanation using 6 columns for ease of following.\\nI will provide the 2 column solution at the end.\\nHere\\nare the 6 column names I used: Row ID, Row ID Comma, Pred Replace FS, Pred\\nCount, Pred Done Count, and Ready Status\\nThe green columns can be converted to column formulas. Unfortunately, I don’t know of a way to get a reliable row ID column using a column formula.\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/NP86T060BMPE\\\/image.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/NP86T060BMPE\\\/image.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Column 1\"},{\"insert\":\": Row ID\\n=COUNTIFS([Task Name]$1:[Task Name]@row, OR(@cell = \\\"\\\", @cell <> \\\"\\\"))\\nIn this example, I have referenced the [Task Name] column, but any column can be used. I stole this formula from another post thanks to Paul Newcome. This formula works regardless of how you move, copy, paste rows. The only downside is that it can’t be a column formula. \"},{\"attributes\":{\"link\":\"https:\\\/\\\/community.smartsheet.com\\\/discussion\\\/69476\\\/row-numbers\"},\"insert\":\"https:\\\/\\\/community.smartsheet.com\\\/discussion\\\/69476\\\/row-numbers\"},{\"insert\":\" \\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Column 2\"},{\"insert\":\": Row ID Comma\\n=\\\", \\\" + [Row ID]@row + \\\",\\\"\\nThis column is the column that will actually be looked up by the counting formula. The commas are needed to avoid false positive matches (e.g. prevent finding “2” in “20”, looking up “, 2,” won’t be found in “, 20,”\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Column 3\"},{\"insert\":\": Pred Replace FS\\n=\\\", \\\" + SUBSTITUTE(Predecessors@row, \\\"FS\\\", \\\",\\\") + \\\",\\\"\\nThis formula adds the needed commas at the beginning and end of Predecessor column, as well as changing “FS” into a comma (needed to ensure a FS predecessor with a lag will still work). Modify this formula with more nested substitute formulas to make it work with other predecessor types (FF, SS, SF) as you desire.\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Column 4\"},{\"insert\":\": Pred Count\\n=COUNT(COLLECT([Row ID Comma]:[Row ID Comma], [Row ID Comma]:[Row ID Comma], AND(NOT(ISBLANK(@cell)), FIND(@cell, [Pred Replace FS]@row) > 0)))\\nThis formula counts the number of rows where the [Row ID Comma] (looks at every row) is found inside the [Pred Replace FS] column (current row only).\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Column 5\"},{\"insert\":\": Pred Done Count\\n=COUNT(COLLECT([Row ID Comma]:[Row ID Comma], [Row ID Comma]:[Row ID Comma], AND(NOT(ISBLANK(@cell)), FIND(@cell, [Pred Replace FS]@row) > 0), [% Complete]:[% Complete], 1))\\nThis is similar to the [Pred Count] column, except it adds an additional condition: the % Complete column must also equal 100%. This condition can be changed to point at a different column (e.g. check box column, Status column, etc.).\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Column 6\"},{\"insert\":\": Ready Status\\n=IF([Pred Done Count]@row = [Pred Count]@row, \\\"Ready\\\", \\\"Waiting\\\")\\nThis column compares the [Pred Count] column and the [Pred Done Count] column. If the counts match, then all the predecessors are finished.\\n \\n2 Column Solution:\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/V3XQ7GBX5FMB\\\/image.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/V3XQ7GBX5FMB\\\/image.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Column 1\"},{\"insert\":\": One Formula Row ID\\n=\\\", \\\" + COUNTIFS([Task Name]$1:[Task Name]@row, OR(@cell = \\\"\\\", @cell <> \\\"\\\")) + \\\",\\\"\\nI combined [Row ID] and [Row ID Comma] into a single formula. This cannot be a column formula.\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Column 2\"},{\"insert\":\": One Formula Ready Status\\n=IF(COUNT(COLLECT([Row ID Comma]:[Row ID Comma], [Row ID Comma]:[Row ID Comma], AND(NOT(ISBLANK(@cell)), FIND(@cell, \\\", \\\" + SUBSTITUTE(Predecessors@row, \\\"FS\\\", \\\",\\\") + \\\",\\\") > 0), [% Complete]:[% Complete], 1)) = COUNT(COLLECT([Row ID Comma]:[Row ID Comma], [Row ID Comma]:[Row ID Comma], AND(NOT(ISBLANK(@cell)), FIND(@cell, \\\", \\\" + SUBSTITUTE(Predecessors@row, \\\"FS\\\", \\\",\\\") + \\\",\\\") > 0))), \\\"Ready\\\", \\\"Waiting\\\")\\nI combined [Pred Replace FS], [Pred Count], [Pred Done Count], and [Ready Status] into a single formula. This can be converted to a column formula.\\n\"}]","format":"rich","dateInserted":"2021-02-02T03:49:23+00:00","insertUser":{"userID":41811,"name":"Tanner Polzin","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Tanner%20Polzin","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!mojB347RWzQ!m6PAXzrhZH4!e2RDlECnGcR","dateLastActive":"2022-11-01T17:14:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/75593\/formula-to-indicate-a-task-is-ready-because-predecessors-are-complete-solution","embedType":"quote","name":"Formula To Indicate A Task Is Ready Because Predecessors Are Complete [Solution]"}"> https://community.smartsheet.com/discussion/75593/formula-to-indicate-a-task-is-ready-because-predecessors-are-complete-solution](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/V3XQ7GBX5FMB\/image.png\"){kind=link}
