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.
use conditionals or formulas to show or hide child rows?
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?
Comments
-
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.
-
Thanks - that's what I thought, but wanted to make sure.
-
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!
-
Hi Zack,
Can you add my vote as well please?
Would especially be interested to hide rows for 'viewers'
Thanks!
Gonnie
-
Add my vote too please. We should be able to hide rows like columns.
-
Gonnie and Brad, I have added your votes!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives