Having some major brain farts today - client needs...
# suiteanalytics
e
Having some major brain farts today - client needs a saved search of Project Tasks that are not yet complete (easy peasy) BUT if there are predecessors, only show the project task if ALL of the predecessors are Complete. Basic criteria setup works if there is one predecessor but not multiple. Thoughts here?
j
I think you're going to need to do something tricky here b/c if I'm understanding correctly predecessor:status applies to each subtask individually. I.e. currently if there is any line where the predecessor:status is not completed and the task status is any of (in progress, not started) then you'll show a line there. So maybe something like do a formula that says 0 or 1 for each predecessor task and then sum by the parent task and do summary criteria?