use conditionals or formulas to show or hide child rows?

Jamison

is this possible?

 

Example:

 

Child rows start hidden.  If a column in a parent row is checked, the the child row is made visible.

 

More info: 

 

I am trying to create a type of set up where I can use a sheet as a form where if the person enters "yes" in a cell, I an guide them to answer the next in a series of questions. This is just one way I am looking at doing that.

 

I could also use columns and use conditionals to blackout the 'downstream' questions, but the is not nearly as nice to look at as a vertical list. 

 

There could easily be 100 questions in this series.

 

Ideally I would use a webform for this  - can one do this sort of hiding in a webform?

 

Amy Johnson

Smartsheet doenst support hiding rows, just filtering and hierarchies. 

 

Neither of these can be controlled by IF actions, you would need to enable/expanded or disable/collapse them manually. 

 

You might consider using Google Forms, which does support conditional questions (if they select Yes show these questions) and Google Forms can feed results into Smartsheet using Smartsheet sync.