Forms

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?

Thanks

Find more posts tagged with

Forms

Comments

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

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

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.

Craig