Forum Discussion

WadeMyers's avatar
WadeMyers
Qrew Member
5 years ago

Evaluate if all records are true

I have a form where I need to evaluate the condition of all records for a true condition. If all child records have been checked (Done), then the quantity of the formula in the parent table should be =1


I attempted it with this formula: If([All WBS Tasks - Done]=true, 1, 0)




------------------------------
Wade Myers
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    You need to have two summary fields.
    # of children
    # of completed children

    Then the formula for ​​the formula checkbox field 
    [All WBS Tasks - Done]

    would be

    [# of children] =  [# of completed children]
    and
    [# of children] >0

    I am assuming that if there are no children,  then you don't want the checkbox checked.



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------