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.


edited 12/09/19 in Archived 2017 Posts

Hi - I am trying to write a form and would like to do the following:

1. Are you a member of XYZ?  If so, what is your membership number?

Is there an easy way to do it or do I have to have a separate column in the sheet and therefore another section on the form?




  • ricki
    ricki ✭✭✭✭✭✭

    If you just want them to be 2 questions then that's easy to do


    Are you a member of xyz?

    If yes, what is your membership number? _____


    The harder thing is if you are asking if there can be intelligence to only ask the second question if the first question is yes. As far as I can tell, that is not possible in smartsheet


  • ricki
    ricki ✭✭✭✭✭✭

    You could also do it as one question and just have the single membership number field in your sheet

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    I agree with ricki's second post.

    In Smartsheet's Forms, you can customize the text displayed, so for a column name [Membership Number], you could display:

    Are you a member of XYZ?  If so, what is your membership number?

    as the header.

    If you need to do counts (how many members of XYZ do we have?) then either

    1. Use the check box method


    2. Count total of non-blank member numbers using COUNTIF or COUNTIFS

    I hope this helps.



This discussion has been closed.