Boolean Formula to Check For Predecessor Condition
Marcello Scacchetti
Ability to have a boolean formula to check completion status of predecessors and return true if all predecessor are completed, false otherwise. If there are no predecessors defined it should probably return true. This could be useful to avoid complex formulas and generate a true/false field to know if the current task could proceed.
Jon Darbyshire
Hiya Marcello Scacchetti, thanks for this post! I have a few more questions for you:
- Can you provide a specific example of a task where this feature would be beneficial?
- How do you currently handle the situation when a task's predecessors are not completed? What challenges does this present?
- Are there any specific conditions or exceptions where the task should proceed even if the predecessors are not completed?
Marcello Scacchetti
Jon Darbyshire Hey, for example in a Card or a Kanban view with the intent of setting up a filter or even a group excluding tasks that are blocked by predecessors being able to focus on what is actionable on hand. Right now the workaround unless I'm missing something (I'm pretty new to the platform) was to create a formula field with the following:
IF(
COUNTIF(
[Dipende Da].[Predecessor (Waiting On)].[Stato] == "Completo",
[Dipende Da].[Predecessor (Waiting On)]) == COUNT([Dipende Da].[Predecessor (Waiting On)])
OR
COUNT([Dipende Da].[Predecessor (Waiting On)]) == 0,
true, false)
That by itself is not a challenge, but fairly complicated to write and get it right. Re if a task should proceed if the predecessors are not completed, can't elaborate much, if a task has predecessors seems to me it is not actionable unless those are completed. Thanks!