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.

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!!

 

 

Comments

  • Jamison
    Jamison ✭✭✭✭✭✭
    edited 01/04/16

    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
    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
    Travis Employee

    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

This discussion has been closed.