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.

Formula to collapse rows

Steve Langford
Steve Langford ✭
edited 12/09/19 in Archived 2016 Posts

I am looking for a formula to collapse the sub-task rows into the parent after all sub-tasks are completed. I found a formula that will check mark the parent row after all sub-tasks are checked complete, but want to collapse when that occurs. I would like to add that onto this formula:

 

=IF(COUNT(CHILDREN()) = (COUNTIF(CHILDREN(), 1)), 1, 0)

Tags:
· Share on FacebookShare on Twitter

Comments

This discussion has been closed.

Categories