# Please help me in advanced skip logic

**URL:** <https://forum.getodk.org/t/please-help-me-in-advanced-skip-logic/10487>\
**Category:** Support\
**Tags:** form-design, odk-xlsform\
**Created:** [November 4, 2017, 7:39am UTC](https://forum.getodk.org/t/please-help-me-in-advanced-skip-logic/10487 "2017-11-04T07:39:20Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![azam\_iqbal](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/azam_iqbal/32/18700_2.png) [@azam\_iqbal](https://forum.getodk.org/u/azam_iqbal)\
**Post date:** [November 4, 2017, 7:39am UTC](https://forum.getodk.org/t/please-help-me-in-advanced-skip-logic/10487/1 "2017-11-04T07:39:20Z")

</div>

Hi Everyone,  
please help me in advanced logic question no WS1 have two logic  
if i select piped into dwelling automatically go to question WS 6 and  
if i select public tap / standpipe go to question WS3 automatically  
please help me to solve this issue

i attach excel file and question pictures ![ws 1 and ws 2](https://getodk.b-cdn.net/uploads/default/original/2X/6/6924357e83d3f7d97aab29d6e806bcde9a300a4b.PNG)

 ![WS3 TO WS 8](https://getodk.b-cdn.net/uploads/default/original/2X/e/ef866856aaf0d60859edb4909ea2b965d780c810.PNG)

---

<div class="post-metadata">

**Author:** ![azam\_iqbal](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/azam_iqbal/32/18700_2.png) [@azam\_iqbal](https://forum.getodk.org/u/azam_iqbal)\
**Post date:** [November 4, 2017, 7:40am UTC](https://forum.getodk.org/t/please-help-me-in-advanced-skip-logic/10487/2 "2017-11-04T07:40:33Z")

</div>

HERE IS MY EXCEL FILE [format household1.xlsx](https://getodk.b-cdn.net/uploads/default/original/2X/7/79cae9675ec766656044a690c30677930c0fe0f5.xlsx) (13.8 KB)

---

<div class="post-metadata">

**Author:** ![azam\_iqbal](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/azam_iqbal/32/18700_2.png) [@azam\_iqbal](https://forum.getodk.org/u/azam_iqbal)\
**Post date:** [November 4, 2017, 7:53am UTC](https://forum.getodk.org/t/please-help-me-in-advanced-skip-logic/10487/3 "2017-11-04T07:53:33Z")

</div>

Pleas put in my excel file skip formula  
i wait response from everyone

---

<div class="post-metadata">

**Author:** ![iamnarendrasingh](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/iamnarendrasingh/32/2593_2.png) [@iamnarendrasingh](https://forum.getodk.org/u/iamnarendrasingh)\
**Post date:** [November 4, 2017, 8:28am UTC](https://forum.getodk.org/t/please-help-me-in-advanced-skip-logic/10487/4 "2017-11-04T08:28:59Z")

</div>

Screenshot is not clear, please send updated screen shot.

Narendra

---

<div class="post-metadata">

**Author:** ![iamnarendrasingh](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/iamnarendrasingh/32/2593_2.png) [@iamnarendrasingh](https://forum.getodk.org/u/iamnarendrasingh)\
**Post date:** [November 4, 2017, 9:26am UTC](https://forum.getodk.org/t/please-help-me-in-advanced-skip-logic/10487/5 "2017-11-04T09:26:25Z")

</div>

Please check below and if possible for you please upload clear picture of logic.  
[HH\_003.xls](https://getodk.b-cdn.net/uploads/default/original/2X/4/4d062f45857eba38d9b931c9e0fb9b98a6e1636a.xls) (32.5 KB)  
[HH\_003.xml](https://getodk.b-cdn.net/uploads/default/original/2X/0/00ea9e52d3025064d49cfe91a86eb54f3c9606c7.xml) (17.7 KB)

Narendra

---

<div class="post-metadata">

**Author:** ![azam\_iqbal](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/azam_iqbal/32/18700_2.png) [@azam\_iqbal](https://forum.getodk.org/u/azam_iqbal)\
**Post date:** [November 4, 2017, 10:27am UTC](https://forum.getodk.org/t/please-help-me-in-advanced-skip-logic/10487/6 "2017-11-04T10:27:39Z")

</div>

Thanks Sir  
Next time i upload picture very clearly.  
and you are given great response on the spot

---

<div class="post-metadata">

**Author:** ![iamnarendrasingh](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/iamnarendrasingh/32/2593_2.png) [@iamnarendrasingh](https://forum.getodk.org/u/iamnarendrasingh)\
**Post date:** [November 4, 2017, 10:36am UTC](https://forum.getodk.org/t/please-help-me-in-advanced-skip-logic/10487/7 "2017-11-04T10:36:13Z")

</div>

Is above form working which i sent?

---

<div class="post-metadata">

**Author:** ![azam\_iqbal](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/azam_iqbal/32/18700_2.png) [@azam\_iqbal](https://forum.getodk.org/u/azam_iqbal)\
**Post date:** [November 4, 2017, 10:40am UTC](https://forum.getodk.org/t/please-help-me-in-advanced-skip-logic/10487/8 "2017-11-04T10:40:52Z")

</div>

yes sir but WS6 has also logic  
if i click ws6 , then automatically go to question 8  
please add this skip in my excel file and yo see in picture  
i wait your early response

---

<div class="post-metadata">

**Author:** ![iamnarendrasingh](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/iamnarendrasingh/32/2593_2.png) [@iamnarendrasingh](https://forum.getodk.org/u/iamnarendrasingh)\
**Post date:** [November 4, 2017, 10:43am UTC](https://forum.getodk.org/t/please-help-me-in-advanced-skip-logic/10487/9 "2017-11-04T10:43:17Z")

</div>

In Q8's relevant section put **${WS6}=2 or ${WS6}=3**

Narendra

---

<div class="post-metadata">

**Author:** ![azam\_iqbal](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/azam_iqbal/32/18700_2.png) [@azam\_iqbal](https://forum.getodk.org/u/azam_iqbal)\
**Post date:** [November 4, 2017, 10:47am UTC](https://forum.getodk.org/t/please-help-me-in-advanced-skip-logic/10487/10 "2017-11-04T10:47:18Z")

</div>

> [@Stalker](#):
>
> ${WS6}=2 or ${WS6}=3

sir no work please check

---

<div class="post-metadata">

**Author:** ![iamnarendrasingh](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/iamnarendrasingh/32/2593_2.png) [@iamnarendrasingh](https://forum.getodk.org/u/iamnarendrasingh)\
**Post date:** [November 4, 2017, 10:50am UTC](https://forum.getodk.org/t/please-help-me-in-advanced-skip-logic/10487/11 "2017-11-04T10:50:54Z")

</div>

${WS6}=2 or ${WS6}=8, now try.

---

<div class="post-metadata">

**Author:** ![azam\_iqbal](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/azam_iqbal/32/18700_2.png) [@azam\_iqbal](https://forum.getodk.org/u/azam_iqbal)\
**Post date:** [November 4, 2017, 10:55am UTC](https://forum.getodk.org/t/please-help-me-in-advanced-skip-logic/10487/12 "2017-11-04T10:55:47Z")

</div>

> [@Stalker](#):
>
> ${WS6}=2 or ${WS6}=8,

sir no work i try please put in my excel sheet

---

<div class="post-metadata">

**Author:** ![iamnarendrasingh](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/iamnarendrasingh/32/2593_2.png) [@iamnarendrasingh](https://forum.getodk.org/u/iamnarendrasingh)\
**Post date:** [November 4, 2017, 11:20am UTC](https://forum.getodk.org/t/please-help-me-in-advanced-skip-logic/10487/13 "2017-11-04T11:20:20Z")

</div>

Please find this and i will appriciate if you will do some troubleshooting by yourself.  
[HH\_005.xls](https://getodk.b-cdn.net/uploads/default/original/2X/1/1c56341dadd83e96035e88b5e9d1047e6dc727f7.xls) (33 KB)  
[HH\_005.xml](https://getodk.b-cdn.net/uploads/default/original/2X/8/86e55c447d8fac94ee802f42551efc036d477684.xml) (17.9 KB)

Narendra

---

<div class="post-metadata">

**Author:** ![azam\_iqbal](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/azam_iqbal/32/18700_2.png) [@azam\_iqbal](https://forum.getodk.org/u/azam_iqbal)\
**Post date:** [November 4, 2017, 11:29am UTC](https://forum.getodk.org/t/please-help-me-in-advanced-skip-logic/10487/14 "2017-11-04T11:29:54Z")

</div>

Thanks Sir  
sir i always remember in my prays  
but i always try to handle first himself,if i am unsuccessful  
then help take from you. and i know you never mind tell me again  
Again Thanks to do fever for me
