Another basic question - I have a column that uses the value in the 'Remaining Effort' to calculate the status of that task.
At the Parent Level I am using Sum(Children()) to sum the Remaining Effort for the Child tasks. This works fine as long as there is a value in this field - if the Task has not started and 'Remaining Effort' is blank then the Sum(Children()) formula will return '0', which is then used to indicate that the Parent Task is complete, which is obviously not correct.
Is it possible to modify the Sum(Children()) formula so that it only sums Child Tasks if their values are not blank? If all the values are blank then it should return "".
Thanks for sharing your expertise!
Help Article Resources
Check out the Formula Handbook template!