# "OR" in a row **URL:** \ **Category:** Ask for Help\ **Created:** [March 23, 2021, 8:29am UTC](https://community.glideapps.com/t/or-in-a-row/24627 "2021-03-23T08:29:52Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![PieroPec](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@PieroPec](https://community.glideapps.com/u/PieroPec)\ **Post date:** [March 23, 2021, 8:29am UTC](https://community.glideapps.com/t/or-in-a-row/24627/1 "2021-03-23T08:29:52Z")
Maybe it’s easy but I’m lost: each customer has 1 row, and he can set 10 consecutive cells (numbers). I would like to have another cell (“check for 0”) that goes to “99” if 1 or more of the 10 cells are set to 0. (“OR” function between the 10 cells). Is any simple method to do that, without using GS? ![or in a row](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/1/3169fe2e8915edd024a55fc64d09be6c9fa29f86.jpeg) ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [March 23, 2021, 8:35am UTC](https://community.glideapps.com/t/or-in-a-row/24627/2 "2021-03-23T08:35:31Z")
Maybe use [https://docs.glideapps.com/all/reference/data-editor/computed-columns/if-then-else](https://docs.glideapps.com/all/reference/data-editor/computed-columns/if-then-else) If column 5LM = 0 then 99 else column 5LM and repeat for each column ---
**Author:** ![PieroPec](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@PieroPec](https://community.glideapps.com/u/PieroPec)\ **Post date:** [March 23, 2021, 8:43am UTC](https://community.glideapps.com/t/or-in-a-row/24627/3 "2021-03-23T08:43:10Z")
It didn’t work (the entire function disappears after a refresh as a conflict) but maybe I did a mistake pointing to wrong cells. I will try again. Thanks ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [March 23, 2021, 8:54am UTC](https://community.glideapps.com/t/or-in-a-row/24627/4 "2021-03-23T08:54:05Z")
> [@PieroPec](#): > > without using GS? Your doing it in the glide builder not google sheet? Just checking 👍 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/a/ba0565bc6f22da83833b963fec29402a08af62ab.gif) ---
**Author:** ![PieroPec](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@PieroPec](https://community.glideapps.com/u/PieroPec)\ **Post date:** [March 23, 2021, 8:58am UTC](https://community.glideapps.com/t/or-in-a-row/24627/5 "2021-03-23T08:58:39Z")
This sheet is also a GS but I would like not to use any function in GS for speed. Anyway, the “if…then” has only 1 else statement at the end. So, if there are multiple situations I think “else” will change between 99 and normal status all the time. Matter of fact, it is not possible to choose “and” or “or” between the different “Add Case”. Am I wrong? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 23, 2021, 9:07am UTC](https://community.glideapps.com/t/or-in-a-row/24627/6 "2021-03-23T09:07:17Z")
The rule for for check column: - If _any_ of the \*LM columns = 0, then 99, else blank Yes? If so, then you do it like this: - If 1LM equals 0, then 99 - If 2LM equals 0, then 99 - If 3LM equals 0, then 99 - … - … - If 10LM equals 0, then 99 And you don’t need an else condition, as once it gets to the end it will default to blank. ---
**Author:** ![PieroPec](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@PieroPec](https://community.glideapps.com/u/PieroPec)\ **Post date:** [March 23, 2021, 9:07am UTC](https://community.glideapps.com/t/or-in-a-row/24627/7 "2021-03-23T09:07:19Z")
Partially solved. In this case I was able to use the “visibility options” where you can use “and & or” functions. I still don’t know how you can do the same on the sheet. ---
**Author:** ![PieroPec](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@PieroPec](https://community.glideapps.com/u/PieroPec)\ **Post date:** [March 23, 2021, 9:09am UTC](https://community.glideapps.com/t/or-in-a-row/24627/8 "2021-03-23T09:09:13Z")
Thanks, Darren!