Formula to pick up next child date that doesn't have a tick

Cathy Byrne

Hi

I have two columns a date column and a tick column, I'd like a formula for the parent row that looks at the children dates and if they have a tick it ignores them, so it just shows me the next upcoming date from the children that doesn't have a tick.

Thanks

Cathy

Kelly Moore

Hey @Cathy Byrne

Try this

=MIN(COLLECT(CHILDREN([your date column]@row), CHILDREN([your checkbox column]@row), 0))

Be sure to replace with your actual column names.

The formula collects the Minimum Child Date that is unchecked.

cheers,

Kelly

Kelly Moore

Hey @Cathy Byrne

Try this

=MIN(COLLECT(CHILDREN([your date column]@row), CHILDREN([your checkbox column]@row), 0))

Be sure to replace with your actual column names.

The formula collects the Minimum Child Date that is unchecked.

cheers,

Kelly

Cathy Byrne

Fantastic thanks Kelly!