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?
Maybe use
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
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
Your doing it in the glide builder not google sheet? Just checking 
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?
The rule for for check column:
Yes?
If so, then you do it like this:
And you don’t need an else condition, as once it gets to the end it will default to blank.
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.
Thanks, Darren!