Hello The data validation box has three answers, blank space, Yes, No)
The answer must be either yes or No but they must answer the question. What
do I do so that the question is answered and not skipped? thank you

I use an adjacent cell that's formatted in a big, bold, red font.

=if(a1<"","","<-- Please answer this question")

But why would you allow 3 answers in your data|validation list.

You could just use Yes and No, but it won't stop users from clearing the cell.
But it will stop them from choosing the blank.

Wanna Learn wrote:

Hello The data validation box has three answers, blank space, Yes, No)
The answer must be either yes or No but they must answer the question. What
do I do so that the question is answered and not skipped? thank you

--

Dave Peterson

Thanks Dave
This works fine. I use the blank so when the form is opened this particular
question does not have an answer but for some reason people tend to skip
this question. I have some rows hidden, and depending if the answer Yes or
No then the rows that apply will unhide. I do not want this question to be
skipped. Is this the right way to do it ? Again Thanks

"Dave Peterson" wrote:

I use an adjacent cell that's formatted in a big, bold, red font.

=if(a1<"","","<-- Please answer this question")

But why would you allow 3 answers in your data|validation list.

You could just use Yes and No, but it won't stop users from clearing the cell.
But it will stop them from choosing the blank.

Wanna Learn wrote:

Hello The data validation box has three answers, blank space, Yes, No)
The answer must be either yes or No but they must answer the question. What
do I do so that the question is answered and not skipped? thank you

--

Dave Peterson

You can select that cell and hit the delete key to clear the contents.

Personally, I don't like using space characters to make the cell look empty.

Formulas that depend on that cell need to be cleaned up.

=if(or(a1="",a1=" ",a1=" ", ......
or
=if(trim(a1)="", ...

to avoid the person who hits the space bar lots of times.

But I would use the adjacent cell with the warning--and even shade (or use
format|conditional formatting) to show that input cell in a different color
until it's filled in.

Wanna Learn wrote:

Thanks Dave
This works fine. I use the blank so when the form is opened this particular
question does not have an answer but for some reason people tend to skip
this question. I have some rows hidden, and depending if the answer Yes or
No then the rows that apply will unhide. I do not want this question to be
skipped. Is this the right way to do it ? Again Thanks

"Dave Peterson" wrote:

I use an adjacent cell that's formatted in a big, bold, red font.

=if(a1<"","","<-- Please answer this question")

But why would you allow 3 answers in your data|validation list.

You could just use Yes and No, but it won't stop users from clearing the cell.
But it will stop them from choosing the blank.

Wanna Learn wrote:

Hello The data validation box has three answers, blank space, Yes, No)
The answer must be either yes or No but they must answer the question. What
do I do so that the question is answered and not skipped? thank you

--

Dave Peterson


--

Dave Peterson