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

Jonathan Chan
edited 12/09/19 in Archived 2016 Posts

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

Query - Show Date under IF constraint.png

Tags:

Comments

This discussion has been closed.