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


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.



Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    edited 01/26/21 Answer ✓

    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.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!