Hiding columns based on yes/no condition

I am working on an implementation form, and would like certain columns to be hidden based on a selection in a previous column.

For example:

Column header: Is program a pilot?

The options are yes and no.

If the asnwer is yes, then the person must complete the following 6 columns.

If the naswer is no, they need to be skipped.

Is there a way I can hide the 6 columns not needed if the response to " Is program a pilot" is no?

Thank you!!

Find more posts tagged with

Conditional Formatting

Comments

Jamison

HI - I would really like the option as well. What i did was just create two forms and have the user select the appropriate one at the time on initiating the form completion. Of course, this then results in two sheets :-(

Brett Evans

You can't hide the column, but you could conditionally format the columns. If you made the text and the back ground both white or grey, the user would know to skip the column.

Travis

Hello - web forms do not support conditions the way you are describing but you can use Smartsheet Sync which connects Smartsheet with Google Forms. Google Forms support setting conditions and Smartsheet Sync will add Google Form entries to a Smartsheet.

Here's more information on Smartsheet Sync: http://help.smartsheet.com/customer/en/portal/articles/1850129-smartsheet-sync-add-on-for-google-forms