Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Display a date on parent row only when all children rows contain date
How may we fix the below formula for parent row so that it displays the most-future-date from children row after all children rows are filled with dates?
=IF(COUNTIF(CHILDREN(), 1) = COUNT(CHILDREN()), MAX(CHILDREN()), 0)
Currently, "0" (nothing) is displayed on parent row no matter whether there is/are dates in children rows or when all children rows have dates.