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.

Jamison

Thanks - that's what I thought, but wanted to make sure.

Zack S

Hello Jamison,

I just wanted to pop in to let you know that I've seen and logged your vote to be able to conditionally hide rows to our enhancement request list.

Thanks for the input!

Gonnie

Hi Zack,

Can you add my vote as well please?

Would especially be interested to hide rows for 'viewers'

Thanks!

Gonnie

Brad Jones

Add my vote too please. We should be able to hide rows like columns.

Travis

Gonnie and Brad, I have added your votes!