How to user all function with Lists

Options

Hello,

I am trying to create a Boolean that returns a true value if all of the "people" who are Children in a list of "All People" have entered True in the "available?" line item.

Basically I have an All People parent item called OCEA with list members of people. The module is dimensioned by people and time. I want the All OCEA available? boolean to be checked if all the children of the All people in OCEA have checked that they are available on a certain day.

Answers

  • Ashutosh
    Options

    Hi,

    Change summary of 'Available ?' Line item as All. Then apply formula on line item All OCEA AVailable ? = Available[Lookup:Parent].

    Note: Parent is another line item which give u parent of childs.

    Thanks

    Ashutosh

  • JoeyP
    Options

    @Ashutosh Thank you so much, that was exactly what I needed to do!