Display a date on parent row only when all children rows contain date

Jonathan Chan

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.

 

Thank you.

 

Jon

Jonathan Chan

The solution is available in below discussion:

 

https://community.smartsheet.com/discussion/using-formula-maxchildren